large number of records in a subform

[totaleuge]

I have a simple Inventory Management database. For my puchasing routine, i
have a 1 to many relationship setup where 1 purchase order form can have many
products in as the subform. Once I entered them in my purchase order form,
the data goes into my tables no problem.

This is good if I only have to enter maybe up to 10 items. Lets say I have
to enter the same 100 products weekly, is there a more efficient way to enter
these data?

My frst approach is to store these 100 products in a sepereate table, but i
will need to have them fill the subform in my main purchas order form as I
enter them.

Thank you for any replaies and ideas...

 

[Allen Browne]

Would it be useful to duplicate last week's order, and then just set the
desired quantity for each item?

If so, see:
Duplicate the record in form and subform
at:
http://allenbrowne.com/ser-57.html