How do parts get listed in an inventory?
ok, I am slowly understanding how relationships work, and I can see how having the serial number thing for the parent key in the Finished Product table will work since every finished product is different, it only needs one number. What I can't figure out is how this will work in the parts inventory table. Yes, every part either made here, or a piece we have to order from some where else can have one digit, but how do I connect each of the pieces with the finished product? I know that I will have to have a table connecting these to, but I do not see how I will be able to sort out the parts that go into the whole. Do I input each part one at a time instead of importing the master inventory list from excel? How do I set up the parts table so that I can see which parts go in the finished product.