How tp let user select a record to delete from database

[kronar30]

Maybe I should start over. I need a way for my users to select a record they want to delete from the database. I was thinking of displaying a small number of key fields to identify the records so the user can choose which ones to delete. Each record consists of several many-to-one table relationships with a unique record in the main table. What would be the best way to do this? I am using Access 97.
Thanks for any help.

 

[dhookom]

Do you have referential integrity enabled? If so, you should be able to use Cascade deletes to remove records from child tables.

I would probably create a form with controls to filter a list box or combo box of records. The user could select the appropriate record and click a button to confirm the deletion of the record(s).

Duane
Hook'D on Access
MS Access MVP