Need to delete some records

[Jessica240]

Hello! Let's get this party started....

I have 2 tables that have a list of procedures and the price we charge for each procedure - neither table has duplicates. One table is my master table which is huge. The other table is a much smaller table, that consists of only the records that I need deleted from the master table (there are about 2,000 records that need deleted).

My goal is to find the easiest way to delete all of the records from the master table if they match the records in the smaller table.


So my plan was to link the 2 tables by the procedure ID and run a select query that would only show me the records from the Master table if they matched the records in the smaller table. So I designed that query, and it was successful. When I look at the data sheet view, it displays all the records I want to delete...... Bingo. Just what I wanted.


BUT then when I go to delete them, Access won't let me. Usually when I run a select query Access will let me edit the records in the datasheet view. I'm assuming the reason why it won't let me edit them now is because I have a relationship created between the two tables.

How do I get around this?



Thank you!!!

Jessica

[Jessica240]

Nevermind everyone... I made the procedure the primary key and so now all is good!!!

[JoeM]

Do you have a Unique ID field in the table you wish to Delete records from (i.e. an Autonumber field)?
Can you post the SQL code of your SELECT query that identifies the records you want to delete (just change your Query to "SQL View" and copy and paste code here)?

[JoeM]

Sorry, didn't see your post as I was typing up my reply.