synergy46

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:

 

RelationshipVL.png

 

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.

2Lots.png

On the Dues tab there is the Dues portal.

(The Lot is a value list that get's it's content from Lots)

 

DueswLots.png

 

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?

 

PostDel77Z.png

 

Is there a solution to this dilemma?  What am I not getting?

Outcomes