Query a record only once, never twice

[Guest]

Please help.
I’m trying to have a query (table1) access data from Table 2 in a drop down
menu (serial #,that part is easy.) after the selection is made, the (serial
#) choice can no longer be available in the query drop down menu again .
Table 1 installed jobs with (serial #’s (info from table 2))
Table 2 installers and serial #’s
I also tried doing a lookup in the table Design View but see no way to
remove used records.

 

[Jeff Boyce]

Robert

Querying, in Access, means looking at. It sounds like you are using the
term some other way, since it isn't real clear why looking at a serial #
would remove it from service.

If you need a way to identify a row in a table as no-longer-available, one
approach would be to add a Yes/No field to record "no-longer-available".
Then, you'd need some way of setting that to Yes/True.

Regards

Jeff Boyce
Microsoft Office/Access MVP