AnsweredAssumed Answered

Filter value list on unrelated table

Question asked by apdofficer on Aug 15, 2018
Latest reply on Jan 27, 2019 by enstorms

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:





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.