AnsweredAssumed Answered

Conditional/dwindling value list

Question asked by sleepandtea on Aug 9, 2017
Latest reply on Sep 4, 2018 by philmodjunk

A little background:

I have a database with a ClinicalFeatures table (includes records of many different symptoms) and a patient table (including patient ID and diagnosis). These are linked by a third table, Patient_Features. On the patient layout I have a portal where I can add different symptoms, but now I want to make this process easier by using a value list. I succeeded in making a conditional value list, where only the symptoms related to the selected diagnosis are displayed. I was also able to make a dwindling value list, which originally shows all the symptoms in the ClinicalFeatures table (not just those related to the specific diagnosis). The problem is I can't figure how to make a value list that performs both of the functions of the above lists; one that shows only the related symptoms and is able to dwindle. Any help is greatly appreciated!