We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Need advice on creating one to many relationship between two custom tables

AmritaT
Tera Expert

I have created two custom tables tab A and Tab B. I can create records on Tab B from Tab A. 

e.g creating problems from inc table.

As per the document, I have created a m2m relationship -

Step 1 -

find_real_file.png

Step 2 - Add the related list to the table -

find_real_file.png

Step 3 - ??   I'm not sure what else to do to add the list of records to be seen under this related list.

 

E.g - I want to be able to see the contracts under the addenda as given below in the screenshot for incident and problem -

find_real_file.png

Please advice. Thank you.

 

 

 

1 ACCEPTED SOLUTION

ggg
Giga Guru

if table A is the parent and table B is the child

create a field on table B of type "reference" and select Table A as the reference table.

Then go to table A, right click at the top of the form, select Configure >> Related Lists >> select your related list.

The child records appear at the bottom of the form.

View solution in original post

11 REPLIES 11

Addenda -> Contract Number relationship is created by a reference field where as Addendas is created with m2m

ggg
Giga Guru

if table A is the parent and table B is the child

create a field on table B of type "reference" and select Table A as the reference table.

Then go to table A, right click at the top of the form, select Configure >> Related Lists >> select your related list.

The child records appear at the bottom of the form.