Good Afternoon Everyone.
Seeking Help.
I have a schedule table with the following fields: (ID, DateCreate, User, Case, Property, CLNA, ScheduleDate)
I have a user table with the following fields: (ID, User, Username, Password, email, CLNA)
I have a Inventory Table with the following fiedsl: (ID, Case, Property, CLNA)
There are 2 types of users Internal and External.
When my internal users schedule properties there user name is added to the User Field in the schedule Table.
When my external users schedule properties there user name is not added to the User Field in the scheduled table. I have added the security option for external users based on the CLNA so that when internal users add to schedule they can see everything associated with there CLNA. The CLNA fields is basically a company ID Field that another system assigns to our external schedulers.
Is there away to stamp the external usersname in the schedule table user field when they add a record. I have to use the scenario above, because the CLNA is the company identifier, and multiple external users have the same CLNA identifer in the users table. This is sorted with the Inventory so each company can only see there properties.