I have two databases that are connected and User access activated
Databases are:
- Employees
- Employee Type
The Employee Type is displayed in a searchable dropdown in Employees
Is it possible to display The Current Users Employee Types AND a Master list of Employee Types?
If I set the field to only show the current user's Types, then it will not also display the master set that everyone can use. If I take this away, then all Employee Types from all Users is displayed.
What would also work is auto creating a database table for each new User that will have the Master Employee Types associated with the Current Logged in User. The data table is only 5 - 10 records and 5 fields each. The fields need to be created at login.