I am working on my first access database project and I have come to a wall.
I build products (about 200) and i buy parts to make those products (about 500). I need to create a form (basically a BOM) listing what parts I use to make each product and how much of that part i use. ie 3 x A screws, 5 x G Washers, etc. I do not use all parts on all products. so there will be some that are not used.
I would really appreciate at any Help i can get.
ultimate goals would be:
identifying all parts required to build a product and the qty and cost
list of parts by vendor so i can keep track of cost changes