billgyrotech
Banned
- Local time
- Yesterday, 21:25
- Joined
- Apr 18, 2013
- Messages
- 258
Hello,
How can I create a login form that will ask for Employee Name (combo box) and password field that once correct will have a different command button on my Switchboard as to what version of the AFRs form to open?
There are AFRs versions:
AFRs1 is Administrator
AFRs2 is Clerk
AFRs3 is Technician
AFRs4 is Research
I have in place an Employees table with foreign IDs from the SecurityLevels table to determine for each employee and also there are passwords.
I have not related these 2 new tables yet and not sure how to put this all together.
I appreciate any help or guidance,
Bill
How can I create a login form that will ask for Employee Name (combo box) and password field that once correct will have a different command button on my Switchboard as to what version of the AFRs form to open?
There are AFRs versions:
AFRs1 is Administrator
AFRs2 is Clerk
AFRs3 is Technician
AFRs4 is Research
I have in place an Employees table with foreign IDs from the SecurityLevels table to determine for each employee and also there are passwords.
I have not related these 2 new tables yet and not sure how to put this all together.
I appreciate any help or guidance,
Bill
Last edited: