Edit button list collector reference

A_112 · ‎11-14-2018

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 · ‎11-14-2018

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.

View solution in original post

A_112 · ‎11-20-2018

I got it working using many to many table relation. I just had to change the 'From Table' to get this working. I came across 'Edit' button UI action which is looking up sys_m2m table for any entry related to the current table i.e. the table on which the related list is present. Thanks.

Chuck Tomasi · ‎12-19-2018

Sorry for the late reply. The notification ended up in the incorrect inbox. Did you get your issue resolved? If not, let me know if I can be of additional help. If so, please mark the correct response above as the correct answer so others with similar questions/issues can find it in the future. Thank you.