I'm trying to create a work sign up interface where certain people are have restrictions on locations. I want the list of employees to be filtered to match the location permissions.
I have 3 tables:
1) Job table: list the jobs, where I can select the location.
2) Location table: links to Employee table and shows which employees have permissions
3) Employee table: links to Location table to select permitted locations
I want to have a column in the Job table that lets me select the employee to assign. I can designate the employee but only from the entire Employee table. I'd like to have that list filtered down to use only the employees that have permissions at the particular location of the job.
I tried linking to the column in my Location table that lists all the employees with permissions, but it just lists all the employees permitted rather than let me select one from the list.
Is there a relationship I need to add to do this or could an app script test the eligibility at the location?
LinkedIn
Twitter
