6 Replies Latest reply on Jul 12, 2012 6:46 AM by matt.rowe

    Join table record deleted even though not set to delete


      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.