Adding a custom table to a sys_user records related list

[Steven Parker]

So we have a custom table for our Applications and I wanted to add a Related List on a user record showing the various "Application Access" that user had.

I know there is a skills table on the user record, but I wanted to see if we could reference our current Application List table somehow.   I don't see it when I click the hamburger icon and click related list as it appears it only shows reference fields as choices there and our list has no reference fields.

How can I add my custom table to the highlighted area below, as "Application Access", so we can pick applications from our current custom list to show on a user record?   Really only need to see the Application name from our list in this related list (and maybe the date added).

[sachin_namjoshi]

You need to have reference of sys_user table in your custom application table.

You can create custom reference field( reference to sys_user) table on your custom table and then you can create related list on user table to refer your custom table.

Regards,

Sachin

[Gowrisankar Sat]

Hi,

You can either make use of relationships

http://wiki.servicenow.com/index.php?title=Creating_Defined_Related_Lists#gsc.tab=0

or you can create a reference field on sys_user table.

Related lists

[Steven Parker]

I replied above with a question about the related list.   Take a look at that if you can help.

[sachin_namjoshi]

You won't get edit button with defined related list.

See example below

Add incidents by same caller related list

You will have to define sys_user reference in your custom table.

Regards,

sachin

[Steven Parker]

So on my custom founders application table, I just create a random reference field to point to the sys_user table?

This is a bit confusing....so I get anytime I define a relationship, I can't use the Edit button...I got that.   But now I see one person saying "create a reference field on sys_user table" and you are saying "You will have to define sys_user reference in your custom table".

What table does the field need to be on and what field should it reference?   Sorry just never had a requirement to do this before and all I see is "Define a relationship" for every example, which doesn't allow editing.