This must be so simple...
2 tables:
dealers
customers
Every customer has a field with the keydealernumber in it.
My relationships are correct: one-to-many (dealers-customers) with a cascading delete.
When I delete a record in the dealer table, it does exactly what it has to do - it's deleted and it's customers with it.
But when I run a query to find dealers without matching customers:
- the query is correct
- I delete the dealers (in the query results)
- I get a confirmation for deleting the records
- I run the query again...and...
floops my records appear again...they haven't been deleted!
What's happening, I need some help here.
Thanks.
2 tables:
dealers
customers
Every customer has a field with the keydealernumber in it.
My relationships are correct: one-to-many (dealers-customers) with a cascading delete.
When I delete a record in the dealer table, it does exactly what it has to do - it's deleted and it's customers with it.
But when I run a query to find dealers without matching customers:
- the query is correct
- I delete the dealers (in the query results)
- I get a confirmation for deleting the records
- I run the query again...and...
floops my records appear again...they haven't been deleted!
What's happening, I need some help here.
Thanks.
