I am in the process of building an inventory database. Using the 300 series classes, I have the database put together. Now, my problem is, I need to have assemblies which uses the individual components in the inventory and I need a way to have the ability to  pull up the assemblies BOM and tell the database to build me 5 of each complete assembly and have the quantities of the individual components removed from the main inventory. I also need the ability to reverse this. Such as, disassemble and the components get credited back to the main inventory.
Can someone shed some light on how to relate the tables and have this happen?