Parts List/Bill of Materials

[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 productsthis 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!

 

[Tom van Stiphout]

On Sun, 10 Jan 2010 19:00:01 -0800, CCD

Maybe this will help:
http://www.mvps.org/access/modules/mdl0027.htm

-Tom.
Microsoft Access MVP

 

[CCD]

thanks! that worked

On Sun, 10 Jan 2010 19:00:01 -0800, CCD

Maybe this will help:
http://www.mvps.org/access/modules/mdl0027.htm

-Tom.
Microsoft Access MVP


.