Query lets me delete but doesn't actually delete...

[kandiyohiv]

I have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close and either re-open table A or the resulting query, that record is back. It doesn't actually delete. If I go to table A directly and delete it, it's gone for good.

How can I make it so that when I delete the record inside the query it actually deletes? And if that's not an option, can I make it so that it doesn't seem like I can delete records inside the query so that people don't make the mistake?

 

[dcobau]

Access will not let you delete, add or modify data using a query that contains fields from 2 tables. If you will need 2 queries to do that or, if you have cascading relationships set up, you could do that directly from the form.

Have a look at the following link

http://allenbrowne.com/ser-61.html

Dave

 

[kandiyohiv]

I can add and edit just fine from the query and it updates the original tables. Just delete doesn't work.