Value list-Can one make Value list used in one field, contingent on the content in another field?
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