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.