I have 3 tables: Members / Lots / and Dues
The relationship is as below:
The Layout is based on Members and has a tabs object with Lots and Dues portals on separate tabs.
On the Lots tab I have the Lots portal. In this example this member owns 2 lots: 22A and 77Z.
On the Dues tab there is the Dues portal.
(The Lot is a value list that get's it's content from Lots)
Let's say the owner of Lot 77Z sells his lot. If I go into the Lots portal and delete 77Z, it also
deletes ALL THE 77Z Lot records in Dues; (see below) even though I do NOT have "Delete Related Records in this table..." turned on?
Is there a solution to this dilemma? What am I not getting?