An Extensible Many-to-Many table

[Makosko]

Guys,

just wondering whether it is possible to create a many-to-many table which extends an existing m2m table ?

Cheers

maros

[Anurag Tripathi]

For what you need i think you have to go through 3 M2M tables only as the extended table wont give you this feature.

Other options can be thought of but they will also require more or less the same amount of effort and might not be that efficient too.

What other option i am referring is you can just create your own Edit button on the extended table, redirect it to a small UI Page that will contain a reference field to change table, just select a chaneg req and submit, and you can attach the selected change req through query in the background. But i personally think this is too much extra work.

So i would suggest having 3 M2M is better option for you.

[Makosko]

looks   like it...

thanks for your help

by the way,do you happen to know which table I would find the default related list label ?

Cheers

Maros

[Anurag Tripathi]

I think this is what you are looking for

sys_ui_list_control

[Makosko]

this works as long as you put some value into the field. What about without it ? A related list still has a label - I wonder whether that is ? Extracted from a table or something like that ?

[Anurag Tripathi]

i think the default name is the related table's name.