I am designing a database for our engineering group. In the database I have the following tables; tProgram, tPartFamily, tAssembly, tSubAssembly, tSub2Assembly, tComponent, tMaterial and tProcess. I have attached a relationship screenshot.
Using search I have found a partial answer to my...