I have three fields in a table ("tblwodLeadTechnician", "tblwodAssistant" and "tblwod2ndAssistant") that are linked to one field in another table ("tbleiEmployeeID"), however, I don't think I have the relationships set up correctly because I'm not able to do many queries in regards to the Employee table. The reason I have it set up this way is because ANY of our employees can realistically fill EITHER of the three positions on any given day. And it does change daily. I'll post the SQL to see if anyone has a suggestion to correct the relationships. SELECT tblWorkOrderDetail.[tblwodWorkOrder#] FROM tblEmployees INNER JOIN tblWorkOrderDetail ON (tblEmployees.tbleiEmployeeID = tblWorkOrderDetail.tblwod2ndAssistant) AND (tblEmployees.tbleiEmployeeID = tblWorkOrderDetail.tblwodAssistant) AND (tblEmployees.tbleiEmployeeID = tblWorkOrderDetail.tblwodLeadTechnician); Thanks!