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.