I am building an inventory management base for my business and am running into a design problem:
1. I have a table for parts.
2. I also have a table for assemblies. Each assembly record has a field that links to multiple records from the parts table.
Simple, however, I want to be able to say how many of each part goes into an assembly. Parts go into different assemblies in different quantities, so that data can’t (and shouldn’t) be stored in the part record.
How can I say one assembly uses 2 of a part and a different assembly uses 3 of that part. (And I need a table of all the assemblies.)
Hope that makes sense! I would appreciate any solutions.