T
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...
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...