Hi I have a mysql database which I connected in DSF. In my database I have a table called “companies” and also another table called “users”. Each company has it’s own id. The ‘users’ table links to the “companies” table by a related table called “company_id”. My question is how would I set a use…

Assigning specific data to a user

formerstaff July 22, 2016, 7:38pm 4

That’s correct. You will need to specify the value of the lookup for each company

Topic		Replies	Views
Custom System Lookup Key Authentication & Security	1	2619	August 1, 2016
Update custom field when updating role? Server-Side Scripting	8	3413	January 14, 2016
Storing data for users Users & Roles	7	5010	August 4, 2016
How to pick up the keys Lookup data created in the User table Authentication & Security	6	2169	February 8, 2016
How to implement data access based on a table with user's permissions Authentication & Security	1	5143	October 23, 2014