New project any ideas?

[Matt Brown]

I need some "Pointing in the right direction" on a new project that i need to get up and running asap.

I need to design a database that allows users to set up a bill of materials with the following fields in a main form:

Assembly Number
Batch Number
Batch Qty


And in a subform:

Part Number
Qty

Okay this part is very straight forward.

The users need to set up at least 50 of these as templates, each template would have a different assembly number as the Pkey.

The next bit is a little more tricky,

What i need to do is call up a part by Assembly number on say a different form and add extra information into a couple of new fields in the subform, i.e. c of c number and then save that complete record away from the template record so the original bill of materials information i.e. assembly number with corrosponding parts does not get overwritten and can be used again in the future.

I thought about creating an append query to do this but had problems with the subforms.

There is proberly a straightforward database model which i could use to do this but i can seem to put my finger on it.

Any help would be appreciated.

Thanks
Matt