Many to Many table related on two records

maxmassaro
Tera Contributor

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

7 REPLIES 7

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)?

Both tables are in different custom scopes and yes I created a relationship. 

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.