Many to many relationship records

Dubz
Mega Sage

Hi All,

I need to relate my service offerings and circuits table so one service offering can be connected by many circuits and a circuit can connect many service offerings.

I've created a many to many relationship in the sys_m2m table so i now have a related list on the service offering and circuit table each listing records related to the other. I can add records to be related with the edit button but i want to automatically create dependencies between the service offering and the circuit when a new relationship is added. Does anyone know where the many to many relationships are stored?

1 ACCEPTED SOLUTION

Gurpreet07
Mega Sage

Hi David,



m2m record have the name of m2m table created.


find_real_file.png



Also you should be able to find out the table name from related list itself.


Right click on related list filter ----> open in new tab


View solution in original post

3 REPLIES 3

Gurpreet07
Mega Sage

Hi David,



m2m record have the name of m2m table created.


find_real_file.png



Also you should be able to find out the table name from related list itself.


Right click on related list filter ----> open in new tab


yep, just saw that myself, cheers Gurpreet!


Dubz
Mega Sage

Actually, just used my eyes and saw the 'Many to Many table' field on the definition record in the sys_m2m table. I guess the relationships are stored there!