Question About Drop Down Options
I have been working with FilemakerPro to create a program for Schools and Teachers (each of these are a separate database).
I have two tables (Districts and Buildings) and a layout for each. These tables are connected by the District ID field so that the appropriate district name shows up on the building layout.
I have a layout and table called "Teacher Info". On this page, I have a drop down list of all of the possible School Districts from my District Table. MY QUESTION IS: how do I create a drop down that shows only the school buildings from the school district that is chosen?
Thanks in advance for your help!