AnsweredAssumed Answered

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

Question asked by user12259 on Feb 21, 2011
Latest reply on Feb 21, 2011 by 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

Outcomes