Help Please….I have 2 tables (tblWorkOrder and tblItemMasterList). Under tblItemMasterList has a Child which is a BillOfMaterial linked by ItemMasterListID. BillofMaterial(child) can have more than 1 item. What I would like to do is be able to open a query of tblWorkOrder and pull out the table from BillOfMaterial by Part Number from tblItemMasterList. Let me know if this descriptive enough otherwise I’ll explain further. Thanks again!
Hey John,
Seems you should have a query that contains all three tables.
In query design view you should link these three tables through primary and foreign keys (if they're not linked allready).
That will give you a query containing more instances of one record from tblWorkOrder table for one record in BillofMaterial table.
In case you need to have a WorkOrder as Master and BillofMaterials as Child then you should do the following:
a) create a query using tables tblWorkOrder and tblItemMasterList
this query should contain ItemMasterListID
b) connect the BillofMaterial table with the query you creates under a) using ItemMasterListID
regards,
h.