Emma
The reason the three conditional relationships originate from the
Products table is because this is where the triggering values for the
value lists are located. Similarly, the phrase 'use only related values
starting from ..." needs to be completed by Products, because it is here
where the desired conditions are being met.
Two rules of thumb: One way I avoid such confusion is to never create
layouts in other than one of the base tables, and never create
relationships between base tables. I expect there are many out there who
have examples when it is best to do so, but when I started developing in
FMP7 I often broke both these rules. I eventually concluded that the
resulting design cul-de-sacs and ambiguous calculation and script
contexts were not worth it. These rules lead naturally to the Buoy and
Anchor structure often recommended for creating relationships and TOs in
the relationship graph.
Ross
Emma Glaisher wrote:
I have huge trouble understanding the part of value lists when it says
'use only related values starting from....'
I had tried putting in the 'higher' levels here, such as Temperature, Group,
but realised from Ross's demo that I should be pointing it at the 'Products'
level. I still don't understand why, but it sure works!
Emma
