Many to Many table related on two records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2025 08:56 AM
I need to add a many to many table on two different table records. Currently can only point to the Many 2 Many table on record.
Example:
Table A Record: related list: m2m_xyz
Table B Record: related list: m2m_xyz
so on table A related list it would look like this
rec123 - recABC
rec123 - recDEF
on table B related list it would look like this
recABC - rec123
recABC - rec456
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2025 10:56 AM
I am referring to the slush bucket; just to confirm, it's not available in the slush bucket for either table? What scope is the M2M created in: same as table A or table B?
Have you created a relationship (System Definition > Relationships)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2025 10:59 AM
Both tables are in different custom scopes and yes I created a relationship.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2025 11:50 AM
Try creating the relationship in the scope of table A and see if you can insert it from there. Make sure there are cross-scope policies that allow read access from the opposite scope.