AnsweredAssumed Answered

Create subset of table

Question asked by Kaps_1 on Aug 6, 2013
Latest reply on Aug 8, 2013 by Kaps_1


Create subset of table



     I have a table of records with fields "Speciality" and "Yes No" in a table called specialities.

     Bricklayer Yes

     Bank Manager Yes

     Accountant Yes

     Chemist No

     Farmer Yes

     Engineer No

     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