Testing for changes in conditional value list
Hello all :)
This is my first FMP forum post, and Ive been googling for hours trying to figure this out lol! Hopefully I can find some help here.
Is there an easy auto calculation to clear all subsequent fields when the top level has changed?
My current fields
If the user first selects
GM>TROY>WALNUT BUILDING> WEST WING> SUITE 201
Then decides to go back and change GM to FORD. It doesn't clear the subsequent selections, and is allowing entry of a "mixed" record, where the red text below are not attributes of the first selection FORD
FORD>TROY>WALNUT BUILDING>WEST WING>SUITE 201