AnsweredAssumed Answered

Create Value List based on a Selection from a Value List

Question asked by senriz_1 on Oct 29, 2009
Latest reply on Nov 2, 2009 by senriz_1

Title

Create Value List based on a Selection from a Value List

Post

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.

Outcomes