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?