Problem With Delete Query

[jo15765]

I have two tables in access 2000 linked together to isolate the records I want to delete. I have them linked by 3 key elements that would leave no doubt they are the records in question. When I change my view from a select query to a delete query, I get a message that states "Specify table containing records to delete"

What did I set up wrong?


Now I get this error:

Single-row update/delete affected more than onen row ofa l inked table. Unique index contains duplicate values

[boblarson]

Access does some strange things when you create a query in the QBE grid and one of them is delete queries with linked tables. What you need to do is go into the SQL View and fix the SQL so it is trying to delete from the right table.