Creating relationship between two tables

MWright1
Giga Guru

Hi everyone,

I have a custom table "Employee Directories" with a Reference field (u_user_name) to the User table.  I would like for the User table to show up at the bottom as a related list.

I created a Relationship record:

MWright1_0-1747401346583.png

 

It does not show up and I don't know what I did wrong...

Please help.  Thanks.

 

1 ACCEPTED SOLUTION

Hi @MWright1 

 

You need to configure it with below steps:

1. Go to Configure Related List

Abhijit4_0-1747403230734.png

2. Find out your relationship name from left side list and add it to right to see it on related list.

Abhijit4_1-1747403289378.png

 

By marking my response as correct or helpful, you contribute to helping future readers with similar issues.
Regards,
Abhijit
ServiceNow MVP

View solution in original post

6 REPLIES 6

OlaN
Giga Sage
Giga Sage

Hi,

Shouldn't it be the other way around?

Since you reference the user from the Directories-table, you can create a related list on the User form, showing all the Directories-records that has the current user selected.

Hi,

I would like for it to show the User related list on the Employee Directories table.

Thanks.

Abhijit4
Mega Sage

Hi @MWright1 

 

It will always have only single record in related list. What's purpose of showing the same information if it's already available in your reference field.

 

or as @OlaN mentioned it should ideally be other way around.

 

Also, if you have direct relation between two tables, you don't need to write relationship, related list will be available to add directly by default. And even if you have created relationship, you still need add the same as related list explicitly.

 

By marking my response as correct or helpful, you contribute to helping future readers with similar issues.
Regards,
Abhijit
ServiceNow MVP

Ideally, I would like to have it both ways.  I also created a relationship from User to Employee Directories:

MWright1_0-1747402704545.png

 

It does not show up either... I must be doing something wrong... 😞