Create Value List based on a Selection from a Value List
In my FMP9 database, two of the tables are School and Students and are joined via ID fields. When a student is entered into the db a school is selected so we know which school they are assigned to. Right now, I have a Value List that connects the studentID to their Name and another that connects the schoolID to it's Name. On a new Form I created I can select a school from a drop-down value list, but I need to create a Value List that shows only the Students who are assigned to the School that was selected from the value list. Is there a way to do this? Thanks.