Hi all,
I have a created a large access database to be used for multiple users. Each user has an employeeID and I want to filter the data they see when they login, based on the data linked to their employeeID.
I know the functionality can be done with this on the login form but I am unsure as to the most efficient way of going about this.
Some pseudocode (I have a background in Java! Ha) for the login form is as follows;
If(userID = 1(Admin))
SELECT * FROM tblJobCosts
else
SELECT * FROM tblJobCosts WHERE USERID = userID.
I would appreciate any advice!! I have just been stuck on this for a few hours now and Im unsure as to the best and most efficient way of going about this.
I have a created a large access database to be used for multiple users. Each user has an employeeID and I want to filter the data they see when they login, based on the data linked to their employeeID.
I know the functionality can be done with this on the login form but I am unsure as to the most efficient way of going about this.
Some pseudocode (I have a background in Java! Ha) for the login form is as follows;
If(userID = 1(Admin))
SELECT * FROM tblJobCosts
else
SELECT * FROM tblJobCosts WHERE USERID = userID.
I would appreciate any advice!! I have just been stuck on this for a few hours now and Im unsure as to the best and most efficient way of going about this.