I am trying to accomplish the following:
I have one table for inventory management for several locations.
Each location has a specific user id, linked to that location via a column [useremail]
The users are only allowed to add/edit/delete their own entries (entries made with the user email that they are signed in with). I can get this right by using the security filter [useremail]=useremail(). This limits their visible data however only to their own location.
I am also trying to give them read only access to all other locations.
How can I get that done?