I didn't know which forum to post this in.

I'm stumped.

The inventory table has both cabinet assemblies and their components (tblInventoryMaster) in one table and a table that has what components go with each assembly (tblInventoryAssembly)

When a cabinet is sold, I need the ordering process to commit the components to ship (but still show the cabinet only on the order)

I've attached part of the database in question (Inventory tables, Order Form & relationships)

Do a search in these forums for BOM (bill of materials).