I have most of this set up. The things I have already.
- Login Page Form on AutoExec
- Employee/User Table With fields like EmpID (Key), Username, Password, First Name, Last Name, Etc.....
- On Every Table in the Database a Foreign Key EmpID field and Relationship on the Foreign Key EmpID to the Employees Table EmpID Key.
This is where I am stuck....
How do I set up for Access to retain the EmpID after successful login and apply that to all the altered database tables when someone changes them?
Basically how does Access know what EmpID is currently using the database and changing records?
Thanks for the help!