Cheeky Charlie
New member
- Local time
- Today, 17:08
- Joined
- Dec 29, 2009
- Messages
- 9
The bottom post of this thread exactly sums up my situation:
http://www.accessmonster.com/Uwe/Fo...5482/Deleting-Records-does-not-Delete-Records
Cases (1): Events (many)
and
Events (1): Payments (0-1)
i.e. each event optionally has a payment. (The Cases table is not involved in this particular question, but is just context)
I have a select query which left joins events onto payments - i.e. it shows all the events plus payments for each event where a payment exists.
When I select a row in the query I want to be able to delete it - and by deleting it, I want to delete the row in the Events table and the row in the Payments table if it exists.
When I try this, the database asks me to confirm the delete, then look slike it's deleted, but if I requery, the records are still there.
I have cascade edits and deletes both switched on.
Any help much appreciated.
CC
http://www.accessmonster.com/Uwe/Fo...5482/Deleting-Records-does-not-Delete-Records
Cases (1): Events (many)
and
Events (1): Payments (0-1)
i.e. each event optionally has a payment. (The Cases table is not involved in this particular question, but is just context)
I have a select query which left joins events onto payments - i.e. it shows all the events plus payments for each event where a payment exists.
When I select a row in the query I want to be able to delete it - and by deleting it, I want to delete the row in the Events table and the row in the Payments table if it exists.
When I try this, the database asks me to confirm the delete, then look slike it's deleted, but if I requery, the records are still there.
I have cascade edits and deletes both switched on.
Any help much appreciated.
CC
