Not sure if this is possible, but I have two different back ends for two groups of people. Group1 has control over table1, and Group2 has control over table2. However, group1 needs to sometimes extract/use/view information in table2, and vice versa for group2 and table1. Group1 and Group2 have their own front ends, call them front1 and front2. Sometimes, group1 needs to view/use but NOT modify information in table2, which is also linked to front1, and vice versa for group2 and table1/front2. So basically, we can see each other's linked tables.
I want to put permissions on front1 so that table2 cannot be edited from front1, and table1 cannot be edited from front2. group1 should only have full control over table1, and group2 should only have full control over table2, but group1 cannot have any modification control over table2, and vice versa. Is this possible or no?