I have 3 tables:
- clients - with link to helpers.id
- client_visits - with link to clients.id
To a client a helper is assigned to, you can enter as helper visit information per client .
So, if a helper enter data in client_visits, via a dropdown he can select the proper client. At the moment this dropdown shows all clients, but it should only show (selectable) clients he is assigned to. Can I add a filter (or via scripting) to this dropdown what reads the helpder user.login (currentUser.email) in order to filter only those clients he is assigned to?