I've a table clients, and a table agents. I would give access at each agent only to the related clients.
every agents have a ID and every clients have the AgentsID which is responsable of that client.
I've given to agents the permissions to see only the records with his IDagent, and it works. Compare the list of clients where is replaces with "?" the records of other agents.
then I want to hide the records of other agent to make the list more clear and so I've create a script that find the records (=IDagents) but filmmaker return "any records comply with the research"
I don't understand. If I give to the agents the permission to see all records, the script works.
How can I do?
thank you a lot