Database Drop down list (Reuse Data)

[Al]

When creeating a database program using ACCESS as a Backend how can I use a Table that can reuse data. Ex: Let's say I have a database I am assigning Names to Computer terminal's. When I delete a record I want the Computer Terminal to reappear in the List table but the record to be deleted

[Lil Dave]

you could have a variable in the Computer Terminal table that is boolean :

Rather than deleting records, I usually set each table to having a IsDeleted record ... that way I can have or not have certain records in a recordset.

You could probably do the same, when you delete a record, it would set a field in the Computer Terminal table to allow it to be shown in the recordset