Filter Value list with boolean value

Discussion created by paulsondervan on Jan 25, 2017
Latest reply on Jan 25, 2017 by 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.



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.


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

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