How to set up access for related table data

(0) Share

Report

Posted on by Peragin

160

Hi there,

I have a solution with the following model. I have custom table A that has a lookup to the contacts table, then I have table b which has a lookup to table A, e.g., table A contains orders, and table B contains the list of items in each order.

When a contact logs in, I can set the relationship so that they can only see their own orders, how can I limit access so that they can only see the items in table B that are associated with their orders in table A.

Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

domliu37 314 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @KH_2437 ,

This can be easily achieved via Table Permission. Try to create a new table permission for Table B, Access Type select 'parent', then select the Parent table permision you created for Table A, finilly select the Parent Relationship (should be something like TableA_TableB)

----------------------
If you enjoy this post, click the thumbs-up button. If it helped you, mark it as a solution so others can find it easily.

Cheers,
Dom

Was this reply helpful? Yes No
Peragin 160 on at

Like (0)

Report
Copy link

Link copied!

Great, I will try this.

Thank you

Was this reply helpful? Yes No
Peragin 160 on at

Like (0)

Report
Copy link

Link copied!

Thanks @domliu this worked, I added a child relationship to table B from the table A_contact table permission.

Was this reply helpful? Yes No