AnsweredAssumed Answered

Filter value list on unrelated table

Question asked by apdofficer on Aug 15, 2018
Latest reply on Aug 15, 2018 by apdofficer

I know this has been discussed, however, I haven't been able to find an explanation of how to create a filtered value list, on an unrelated table as I am trying to do. The actual relationship happens after making a selection from the drop-down value list.

 

I have a "staff" table which includes the following fields:

staffName

staffPosition

staffStatus

 

I then have a "classes" table. From the class table I want to assign teachers to a class. In the classes table, I have a "teacherName" field, which is a drop-down value list. It is currently showing all staff members, from the staff table. However, I would like to filter this list to show only "Active" staff and staff members that are "Teachers".

 

If this topic has been answered, it would fantastic if someone could provide the link.

 

Thanks

Outcomes