Batman1458
MIS
I apologize, but it has been a few years since I wrote an Access DB and am a bit rusty. I have a schedule DB I am writing. Only certain employees are allowed to work at certain locations. I have a tables: [Employee], [Locations], [Schedule]. In the [Employee] table, I have a field that allows the user to check a box, to identify which locations the employee is authorized to work at, based on a lookup, from the [Locations] table. I can query this and return the results of which employee is listed for which location.
SELECT e.FullName, l.locname
FROM Locations AS l INNER JOIN Employee AS e ON l.ID = e.EmpLocation.Value
GROUP BY e.Fullname, l.locname;
On the [Schedule] table, I am creating a form, in which you pick the location requiring service (schlocation). Based on the location entered in this field, I would like to limit the results that show in the next field (schemployee), based on who is authorized to work in that location, which is defined in the [Employee] table previously mentioned.
Thank you for the help.
SELECT e.FullName, l.locname
FROM Locations AS l INNER JOIN Employee AS e ON l.ID = e.EmpLocation.Value
GROUP BY e.Fullname, l.locname;
On the [Schedule] table, I am creating a form, in which you pick the location requiring service (schlocation). Based on the location entered in this field, I would like to limit the results that show in the next field (schemployee), based on who is authorized to work in that location, which is defined in the [Employee] table previously mentioned.
Thank you for the help.