AnsweredAssumed Answered

Dropdown/Value List of filtered results?

Question asked by ezeitgeist on Feb 10, 2017
Latest reply on Feb 10, 2017 by philmodjunk

I have a table of Families, and a table of Students. The Students are associated to families by Family_ID.


Is there a way I can create a Value List (or populate options for a Dropdown list) that only has the specific Students that are associated with the specific Family_ID that is associated with the current record in the Family layout?


Ie. Janie and Johnny are students in the Smith family. Kevin and Sarah are students in the Johnson family. When in the Smith record layout, I want the dropdown list to show only "Janie" and "Johnny" as options.