I understand what you're saying but, I'm confused about 1 portion. I've created a simple database where I have the following tables:
UsersT
ProgramsT
UserProgramT
I set up the relationships where UserProgramT is linked to each FK (Users and Programs). but, how do I then associate user "Keith"...
I'm new to Access and have been creating a database to track and monitor what programs our employees have access to. Now, I want to run a report to show who has access to a single program. The problem is, the program could be in any column in the table.
Here is what the table looks like:
I...