Limit the options in the dropdown based on the selected value of the parent reference.

[heaume]

Hello,

I have an issue I can't solve.
I have 3 tables: school, student, and courses.
Each school has some students, and I would like to create courses for a specific school. I also need to add students to the course. When I am on the courses form, I have a dropdown for selecting a school, and only after selecting a school does the dropdown for students appear. However, I would like the student dropdown to only show the students belonging to the selected school.

I tried using this formula in the Valid If field for data validity:
SELECT(student[student name], [student].[school] = [school])

But it still shows all the students, not just the students for the selected school.

Does anyone have any idea how to solve this?

Thank you so much in advance!

[WillowMobileSys · Accepted solution]

I think you just need to modify your SELECT to this:

SELECT(student[student name], [school] = [_THISROW].[school])

[heaume]

this is working 👍 thanks !

[heaume]

Thanks ! 👍