I have 3 tables.
User - contains list of users
departments - contains list of departments
user_departments - contains a list of users and department assignments
I need a dropdown that lists the departments names, based on the current user.
My choices source is “Search for deppartments’s name” and I have a constraint that is a search for user_department’s ID, where the current user’s ID is in user_department.
When I have a single value in user_department, the dropdown box works. As soon as I add a 2nd value, it fails to return rows.
Are you unable to pass a list through 2 “search for’s” when loading values?