Add to Data

[LindaC]

I have one form I am using for users to enter info on their archive records.
They will input all fields except the location in the warehouse where their
records will be kept. This will be done by our warehouse. Once a user has
entered say 10 records, is there a way of advising the record keeper to add
the location, for example BB6. If not, should she just run a query each day
to see if there are any records that need location numbers? Thanks

 

[Smartin]

I have one form I am using for users to enter info on their archive records.
They will input all fields except the location in the warehouse where their
records will be kept. This will be done by our warehouse. Once a user has
entered say 10 records, is there a way of advising the record keeper to add
the location, for example BB6. If not, should she just run a query each day
to see if there are any records that need location numbers? Thanks

Are the data entry folks and the record keeper different people? If so,
I think it would be simplest for your record keeper to just run a query
on demand to find records that need location numbers.