BigRed1212,
Thanks for the post. I followed your logic and it works, but my setup is a little different. Instead of using a table to determine what location each employee can work at, I am using a list box, within the employee table. Is there anyway to accomplish the same thing, while using...
I have a location table that lists criteria for the locations. Employee table, that has a lookup field, linked to the location table and allows multiple locations to be selected by check box. The employee table is where the authorized locations list is kept, for each employee.
Thanks.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.