Hello, i implement the Advance security question and enable Parent user id on my contact table, so i create a field under my clients table and named it userconnections, so on Advance security question i select mu contactid as parent userid field and down under my clients table i select userconnections as the connections field with the parent,
so when i do the conections the field hold on my database records as: 2,4,8 that are the contactsid number.
so i was thinking it was working properly but not, the result is just the first contactid on the field has access to this client, in this case (contactID 2) the others notso my question is i am doing properly the setup?
Hello, i will try to post here what you ask, but my question is if employees need to access clients. on this case the Parentuserid could be the contact_id on the employee table? and a field on the clients table that hold the contactids that has access?
i did, but my scenario es different i think, on demo project is employees access to same tbl employeemy situation is employees get access to clients table so there is not how use Advanced security - Parent user id
You should re-evaluate again your tables. If employees and clients both should be able to login, then try to use one table to store employees and clients, and to distinguish between employees and clients, you may create a field, for example “user_status” char(1), which is 1 = employees, 2 = clients.