Hallo community, I need a bit help with table permissions. I have created three main tables that I am using in a canvas app to plan trips.
The Tables are related to each other like this:
- General Trip Details table
-> Trip Location table (n:1)
-> Trip Budget Items table (n:1)
For every new row in the "General Trip Details" table, I create two access teams to define the permissions for the users. One team has "read", the other has "write", "delete", "append" and "append to" rights.
The challenge now is, that I don't want the user to have full access on the "General Trip Details" table, but are able to create, delete, append rows in the Location and Budget Item table that are related to the row in General Trip Details table.
So let's say I create two trips called "Business trip to Munich" and "Factory visit Berlin" and want "John" to create the budget and different meeting locations for the trip to Munich and "Laura" to organize the Berlin visit. I don't want Laura to be able to have access to the Munich items and the same for John on the Berlin items. Also, Laura and John should not change or delete the General trip details. They should be able to create, change and delete items for their assigned trip.
Is that possible to accomplish? Does anyone can help with this?
I would appreciate any help.
