Recent content by khohense

I think I follow. The self-junction table only needs two fields, a parent and child, which are both pulled from the inclusive BOM table. And being able to easily apply a PO to the fabricated "assembly" is important since labour is typically applied as a single PO for the assembly of the...

What I'm trying to do is improve our workflow from dozens of excel spreadsheets into a relational database, while trying to reduce changes to other processes. The primary purpose of the database is to store purchase orders. The BOM is a list of parts that need to be purchased. Each part in the...

Thanks for the quick reply! Simpler is (almost) always better, so I will go with a separate join table and see how that works.

Hi All, I'm fairly new to access, and I've run into an issue and I'm not sure the best way to proceed. I have a many-to-many relationship between two tables (BillOfMaterials and PurchaseOrders) with a join table (PurchaseOrders_BillOfMaterials). I have a second table (FabBillOfMaterials) that...