Help Please….I have 2 tables (tblWorkOrder and tblItemMasterLi st). Under tblItemMasterLi st has a Child which is a BillOfMaterial linked by ItemMasterListI D. 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 tblItemMasterLi st. Let me know if this descriptive enough otherwise I’ll explain further. Thanks again!
-
-
Originally posted by John Torres
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 tblItemMasterLi st
this query should contain ItemMasterListI D
b) connect the BillofMaterial table with the query you creates under a) using ItemMasterListI D
regards,
h. -
Thank You very much.....It works....:>)
Originally posted by hjozinovicComment
Comment