Record access based on logged in user
Posted on 2012-09-18
Hi, I am trying to create a Filemaker 11 db application that will display records based on the user logged in. I am coming from a .net/sql server web background.
I would like to have employees that log in individually and then only have access to view or update their clients. And clients can be assigned to more than one employee. I can't figure out the piece between the login (set up under Manage -> security) and record access. In .net I would have a client table, employee table, and a table that related the 2. How do I accomplish the same thing in Filemaker? Thanks for any help.