M2M display fields in list view

[Momiji]

How do we display the fields in the list view? When a non-admin uses personalize list columns, only the 2 reference fields are available. I know we can configure it using list layout, but for those non-admin, they don't have access to it. I'm thinking of creating new fields to the M2M table that have the same attributes to the fields from the 2 referenced tables, and then creating client scripts and business rules. But is there any simpler way?

Thank you in advance!

[l457]

You are typically allowed an unlimited amount of m2m tables but only three (I think) additional fields on them before they become standard tables that will eat into your subscription. Even without this condition what you describe with brs is not sound practice. In general avoid unnecessarily replicating data.

How I would suggest approaching this is by consulting the defined process. This should dictate what the key attributes are, based on this it should be possible to define a default view or multiple views with the necessary dot-walked fields to do what it is that is done with this information for the intended personas. The users can then personalize from this view to tailor to their needs or preferences.

For example if a user asks for a certain field to be visible in a related list, it should/would make sense that everyone else working that process needs the field visible to complete their work, otherwise it hints at problems in the process.

[larsonv]

Hello, If possible, use dot-walking from the reference fields  and check the ACLs/dictionary settings.