I want to set it so users can only see and edit their own data. And i did this through the Advanced security settings with a ownerid column in the master table (tbl.customer). This works fine and users can only see/edit their own data in tbl.customer, however since tbl.customer is linked to a child orders table (tbl.orders), users can still pull up / edit everyones tbl.orders data. I can hide it by removing the link from the menu view, but users can just type in the url to the table. Anyway, I tried to set security settings in tbl.orders in the Advanced security settings, but I don't want to make another column for ownerid in tbl.orders, since the ownerid is already in tbl.customer which is the master table. Instead I changed the tbl.orders query to left join with the tbl.customer table to grab the ownerid field. Did that and changed on settings of the tbl.orders so only when the ownerid on users = ownerid on tbl.orders. However, it is still allowing users to see all the data in tbl.orders. I did tested this by creating a ownerid column in tbl.orders which worked fine. Is there any workaround so I can just use the ownerid in the master table? Thanks much.
