Trying to add a Related List to a custom table, but only have Attachments as an option

[paulchicago5]

I created a custom table to track web site certificates. The table is built out with forms and works fine. I would like to associate items from my servers table to the table, but when I try to configure Related Lists in my new table the only option that appears in Attachments. Every other table to relate to is missing. What am I doing wrong? Thanks.

[Filipe Cruz]

I think you can solve it by going to System Definition > Relationships and create a new record to relate your custom table with the servers table.
Let me know if that helps!

[Maik Skoddow · Accepted solution]

Hi @paulchicago5 

related lists are only offered if other tables have reference fields which are pointing to your custom table. And therefore you are only offered attachments as attachments can be related to all tables. So on your server table add a field of type Reference and type of your custom table. Then check again.

The other way of building related list between is creating relationships. This approach is used if there is no reference field on one table. But you have to find a rule how these two tables are related to each other.

Kind regards
Maik

[Filipe Cruz]

@Maik Skoddow but in this case a new unused field will be created.
As stated in the docs.servicenow.com:

Defined related lists allow relationships between arbitrary tables to be expressed as a related list. Any two tables that can have a logical relationship can appear as a parent/child pair via a related list.


https://docs.servicenow.com/bundle/sandiego-platform-user-interface/page/administer/form-administration/task/t_CreateDefinedRelatedLists.html

@paulchicago5 

[Maik Skoddow]

Hi @Filipe Cruz 

did you read my answer carefully? I talked about two ways. For the first way you are right regarding the new field. Whether it is unused or not only @paulchicago5 can decide. 😉

And by the way: This is the common way as reference fields are one of the most important field types at ServiceNow.

Your mentioned documentation page is about what I said in the second part of my answer: "The other way of building related list between is creating relationships. This approach is used if there is no reference field on one table. But you have to find a rule how these two tables are related to each other."

Kind regards
Maik