Creating relationship between two tables

[MWright1]

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:

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

Please help.  Thanks.

[OlaN]

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.

[MWright1]

Hi,

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

Thanks.

[Abhijit4]

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.

[MWright1]

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

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