I have create a login form for my users to login to my database. Once the login is successful I want the form check to open up with only that user records that is assiged to them via the empnumber field which has there assigned number.
The employee table there is an acccess level field.
When the user login I want them to open the checks form because they can only add notes. When they login I want them to be able to see their empnumber records only, no other employee records.
When admin and tech person login I want the checks admin form to open with all records available.
I have attached a small version of my database. Thank you so much.
The employee table there is an acccess level field.
When the user login I want them to open the checks form because they can only add notes. When they login I want them to be able to see their empnumber records only, no other employee records.
When admin and tech person login I want the checks admin form to open with all records available.
I have attached a small version of my database. Thank you so much.