2 Replies Latest reply on Feb 21, 2011 6:46 PM by user12259

    Value list-Can one make Value list used in one field, contingent on the content in another field?

    user12259

      Title

      Value list-Can one make Value list used in one field, contingent on the content in another field?

      Post

      Concerning Value lists:

       If I have two fields say - Field A and Field B; then I would like the value list used for Field B to be determined by the content of field A.  For example assume Field A can be the name of one of three drugs - (Morphine, Dilaudid, or Fentanyl).  Field A will determine drug choice.  Field B will then be the dosing options for that drug.  For each choice of drug in Field A, I would like Field B to use a separate value list.  

      I could put all the the dosing options for all three drugs into one value list for Field B, but that is a long list and provides too much opportunity for error.  Is there a was to make the value list used in Field B, contingent upon the content of Field A?  

      Thank you.  Paul

      Using Filemaker Pro Advanced 11.0v1