Re: Data for form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: [MVP] S.Clark (steve.clark_NOSPAM_at_FMSInc.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 18:12:45 -0500

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. 

-- 
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
"Yuri Greene" <YuriGreene@discussions.microsoft.com> wrote in message 
news:C6AAA7A3-FB04-47EB-BA73-2C862DB67B14@microsoft.com...
> 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?
> -- 
> Thanks,
>
> Yuri