6 Replies Latest reply on Oct 12, 2011 2:36 PM by droths

    Validation of relation between two fields



      Validation of relation between two fields


      I am a newbie, evaluating FMP11 for a distributed company environment. One problem I have is with validating conditional value lists. I am able to created two tier lists such as Product category > Item (ie filtered to only show the category's items. (eg http://help.filemaker.com/app/answers/detail/a_id/5833/related/1) However, I cannot find a way (or a help function) for the system to FORCE a correction of the subsidiary (item) field if I then edit and change the parent (category) field from a dopbox or popup. eg
      If Tools - Hammer is set and I change Category to electrical and exit, Hammer still shows, but is incompatible. I have tried the various validation settings but to no avail. I presume that some algorithm or script will be necessary. This is a key data entry requirement and I am sure embedded somewhere in the documentation. Hope someone can help