Issue with Edit Button in a related list

gabrielon · ‎10-18-2017

Hi all,

we have an issue with the Edit Button in a Related List.

First of all, I have to describe you the situation as it is.

We have two custom tables, table Component and table Blueprint. In the form of the Component we have a List Field with the blueprints that are associated to that Component. In the form of the Blueprint, we have a Related List of the components that are associated to that Blueprint. When we are on the form of the Blueprint, we want to add components to that Blueprint and we use the Edit Button to accomplish it.

We actually can add more components to the blueprint with the Edit Button, but the issue is that if a specific component is present in another blueprint, the component will be moved from the old blueprint to the new one, and not being added to, as we want. We tried to configure the Edit Button in the List Control but we didn't figure out how to append the new blueprint to the List Field without replacing the old one. Can you please help us?

HarshTimes · ‎10-19-2017

Hi Gabriele

Yes, the List also reference to a table. It also behaves similar way. your both tables are connected via a single field. Whenever you add the new values from edit then it will override the old value.

You will be required to setup a m2m table for your solution.

Check the below link to know how to create m2m table.

Creating a Many-to-Many Relationship - ServiceNow Wiki

Regards,

harsh

View solution in original post

gabrielon · ‎10-19-2017

Actually my tables are connected by a List Field, not a Reference Field.

The Relation is already N-to-N (many to many😞 actually I can add more blueprints to my components, and more components to my blueprint, if I do it manually (through the Component record, adding more Blueprints in the List Field).

I should need an "Add Button" that allows me to append more blueprints in the List Field of the Component Form, instead of overwrite all of them with the new blueprint.