Parts List/Bill of Materials

  • Thread starter Thread starter CCD
  • Start date Start date
C

CCD

I'm trying to create a Parts List/Bill of Materials in Access 2003. I am
somewhat of a new user and having difficulty building the database. I'll see
if i can describe what 'm trying to accomplish. The alphanumerics below are
part numbers.

i have a list of final products:(this list can be up to 5000)
P1000
P1001
P1002

Each product is made up of different components (this list can be up to 300)
C1
C2
C3

Each component is made up of different parts(this list can be up to 200)
L1
L2
L3

Example: P1000 uses (2)C1's and (4)C3's. C1 uses (1)L2 and C3 uses
(2)L2's, (1)L1 and (1)L3

Each product can be made up of different types and quantities of components
and each component can use different types and quantities of parts.

I need to count the amount of Parts(L#'s) in each product

Please help!
 
Back
Top