FM 16 adv - mystery value list behavior

Discussion created by synergy46 on Oct 19, 2017
Latest reply on Oct 22, 2017 by greatgrey

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?