Sharing Custom Object over Custom Junction Object
I have the requirement to share a record of a Custom Object "Trial" to multiple Contacts in a Community if they have a connection. The connection between the two object is a junction object called "Trial Contact".
- As example, there are two Trials named "A" and "B"
- Contact X of Account E should only see Trial "A" - 1 record in "Trial Contact"
- Contact Y of Account F should see Trial "A" and "B" - 2 records in "Trial Contact"
- Contact Z of Account G should only see Trail "B" - 1 record in "Trial Contact"
What is the best setup of relationships (lookup/master detail) to fullfill this requirement?
Thanks for any advice!
댓글 2개
@Jürg Steudler I haven't actually attempted this, but my first instinct is to create a lookup relationship on Trial Contact to Trial. To actually share, trigger creation/removal of Trial Share records based on the Trial Contact records created/deleted.