Hi
Sorry people this is probably really simple but i want to set up an Access database to keep on track of peoples permissions to systems.
Basically one user will have access to a number of different systems (up to 4) and would then have different levels of access to these systems (levels themselves could change).
So User A could have access to 4 systems. System 1 he has 3 different permissions, system 2 he has 4, system 3 he has 1 and system 4 he has 6.
My question is how would it be best to build this in MS Access. Im ok at running queries etc but i am struggling finding the best way to setup tables.
Many thanks