BOM bill of materials problem

[JaY]

Hi!

I have a big problem:

I have 2 tables
Table1
PartID Description

Table2
PartID subpartID Quantity

From that I need to get bill of material
I found some solutions but I can only use this fields in tables

Thank You
Igor

jay_REMOVE_ THIS [email protected]

 

[PC Datasheet]

You need to redesign your tables. Check this:
http://mvps.org/access/modules/mdl0027.htm