2 Replies Latest reply on Jan 25, 2017 12:57 AM by paulsondervan

    Filter Value list with boolean value

    paulsondervan

      My program has 2 tables (Patient and PatientAfspraken).

      Patient and PatientAfspraken have a relation by the Arts (= Doctor) code.

      The Patient table has a boolean field Overleden (= Dead), value 1 means the Patient is dead.

      FilterValueList.png

       

      In the screen after selecting the Doctor, I have a Pop-up menu with a Value list that contains all the patient for the selected Doctor.

      SelectionScreen.png

      I want to omit the dead patients in the Value list.

      Is this possible and if so how can I do this?