Join table record deleted even though not set to delete

Discussion created by matt.rowe on Jun 14, 2012
Latest reply on Jul 12, 2012 by matt.rowe

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.