Access 2007 SubForms

[Steve Blake]

I am attempting to build a database which will be used to enter bills of
materials. In my effort, I am building a single table with parent part
number, child part number and quantity. Perhaps this isn't the way to
approch this task but this is what I am trying.

Now, what I would like to do...

A top subform would be used to enter the parent part number and the bottom
would be used to enter the child part number and quantity.

This will all be entered into a single record within that table (bom).
With this concept, the data entry person would not have to add the parent
part number for every record.

Any assistance would be great.

Thanks.


Steve Blake