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.