Create subset of table
I have a table of records with fields "Speciality" and "Yes No" in a table called specialities.
Bank Manager Yes
I am trying to make a related table which consists only of those records where "Yes No" equals Yes. I have done this by having a third field called "Always Yes" - which equals yes. I have created an instance of my "specialities" called "active specialities".The attached screenshot shows my relationships - but I cant seem to make it work. Any thoughts ? thanks