I have two "main" tables related via a "join" table: Leases--<LeaseLetUnits>--LettingUnits.
On one side of the join table [Leases--<LeaseLetUnits] LeaseLetUnit records are set to delete if a Lease record is deleted.
On the other side of the join table [LeaseLetUnits>--LettingUnits] they are not. The join table [LeaseLetUnits] retains LettingUnit info via a number Lookup Fields which are populated when then the record is created (I assume).
My problem is that when I delete a LettingUnit record, it also deletes the LeaseLetUnit record, even though "Delete records...." option in the relationship dialog is unchecked.
Any help would be much appreciated.
Thanks in advance
Message was edited by: matt.rowe Here's the file with some dummy data, in case anyone wants to have a look.