Relationship and/or layout problem.

[ron G]

I am using fM 12. 03 ON OSX

 

I have a global table that has no relationship to any other table.    95% of this table holds global fields.   (Lower left corner below)

 

 

I have a 'Setup' called LAYOUT that is based on Members.    (Basing it on other tables (including global) means that the portal values holding the global fields will not show anything.)  

 

Below is the Setup Layout (based on Members)

 

THE PROBLEM: 

For some reason, if I am on the Members layout and I delete a Member record, it WIPES OUT THE GLOBAL TABLE!  Huh?

I can add member records without incident.  But, I can not delete a member record withoout wiping out Global!

 

I wrote a script to see what happens:

 

I am lost as to why this happens....

 

Please help with your insights.

 

Thanks

 

Ron

 

 

 

 

[ron G]

The problem resides with my development version .998 .  

 

I just went back and ran version .992 and it worked perfectly.

 

So, I copied the script from 992 to 998 and it deleted the global table.

 

I made sure that that the Setup Layout (based on Members) was the same in each version. 

I made sure that the scripts are the same. 

 

So, the scripts are the same.  The tables are the same.  There is no reltionship to Members from Global in either.  Both layouts are based on Members.

 

Yet, 992 works and 998 does not.  ????

[ron G]

Got it!

Someone (certainly not me!) changed the relationship setup to 'Delete Records when Records are deleted in Members'....  (Kicking self .....)