Hi Guys,
I'm trying to filter a dropdown based on user selection from a radio button.
Just trying to figure the best way to approach it...
Any ideas would be highly appreciated
Scenario:
I have a team_table that records data for individual team members.
A team member can be either level 1 or level 2, this value is selected by the user from a radio button called team_level.
I have a team_courses_table setup as a detail table off the team_table where I plan to record data on courses individual team members have attended.
This detail table contains a dropdown called "Courses" which is a lookup of all the courses available in the courses_table (over 200 courses to choose from). The corresponding level i.e. Level 1 or Level 2 is also a field in the courses_table.
Any ideas what would be the best way filter the courses dropdown in the team_courses_table detail table to only show level 1 or level 2 courses based on the user selection from the team_level radio button, for example if the user chooses level 1 from the team_level radio button the courses dropdown will only show level 1 courses to choose from.
Best wishes,
J