Data for form

[Guest]

Currently I have a form that is using data from a table that is being
appended to by a query to add new items. In this table two fields are updated
by the user of the form. One of these fields however is a minimum order qty
field that is maintained by the user, the other field that is updatable
through the form is an order qty that is also keyed by the user but it zero's
out after the order amounts have been keyed and a po report is generated for
the desired items. I would like to be able to delete this table and recreate
it weekly to get rid of the items that we no longer purchase. I have tried to
seperate the active item and minimum order qty into a new table called
minorqty and keep all the other fields the other table linking item to item
in a query. Basing the form on the a query instead. Once this is done the
data is no longer updateable. Is there a better way to do this?

 

[[MVP] S.Clark]

I would think that you would have a table of products and then a second
table of which the user performs the data entry and in the products table
there could be a field that when checked the user would not see that product
because it was obsolete.