Edit button list collector reference

[A_112]

Hi,

I have a related list present on a custom table and I have configured an 'Edit' button on this related list. My query is regarding the list collector that a user will see when clicked on this 'Edit' button. Currently the 'Edit' option on related list opens list collector with a list of values from say in left bucket from say Table A. This Table A has a field which references Table B. Hence when a user clicks on Edit button, I want that the user sees the values from Table B.

Please see an example with screen grabs in the attachment.

Currently I am trying to achieve this using relationships (sys_relationship) table but no luck with this.

Thanks in advance.

[Chuck Tomasi · Accepted solution]

Have you taken a look at Many-to-many tables? The classic example I use is groups and users. You can have many users in a group and many groups assigned to a user. When you see the list on the user profile, it says "groups" and clicking the edit button brings up a list of groups. When you see the list on the group table, it says Users and brings up a list of users when Edit is clicked.

[A_112]

Chuck,

My first thought was to try out sys_m2m and with that I partially achieved what I needed.

The user and group example is fairly straight forward. In both tables you see the display values present in either tables. What i need is to see display value from a third table which is a reference to a field in the table in related list.

My expectation is:

When user clicks on edit button:

1. Right bucket - show the exiting names from ‘HUID Okta Group Members’ table. These are same names that is seen in related list record below the 'Edit' button.

2. Left bucket - show the names from ‘HUID Accounts’.

In short the names seen in the related list are actually present in a different table say table 3. These names in related list are reference values from table 3.

Hope I could give a clear picture of my requirement.

Please refer to a new attached file that shows 2 scenarios, one without using many to many and another with many to many.

Thanks

[Community Alums]

You cannot display different things in the right and left panes in the slushbucket. That would be terribly confusing to someone. Consider the users & group again. If I saw "Chuck Tomasi" on the left as available, then moved it ot the right and it suddenly said something like "Marketing" (some data from a different table) I would think "Wait, what did I just add? Where did Chuck go? How do I get it back? and why do I have three Marketing entries instead of "Chuck", "Megan" and "Jason"? See what would happen?

[Chuck Tomasi]

You cannot display different things in the right and left panes in the slushbucket. That would be terribly confusing to someone. Consider the users & group again. If I saw "Chuck Tomasi" on the left as available, then moved it ot the right and it suddenly said something like "Marketing" (some data from a different table) I would think "Wait, what did I just add? Where did Chuck go? How do I get it back? and why do I have three Marketing entries instead of "Chuck", "Megan" and "Jason"? See what would happen?