How to create a related list

[ty_roach]

I was trying to follow the example for creating a related list using this wiki article:

http://wiki.servicenow.com/index.php?title=Creating_Defined_Related_Lists

...but I'm not having any luck. Here's what I've done:

I created a table (u_my_table) that I want to appear as a related list to change_request. NOTE - I did not extend change_request table when creating "u_my_table", I just created it from scratch - a very simple table with minimal fields.

In u_my_table, I created a reference field (u_change) that references the change_request table. Next, I created a relationship ("System Definition -> Relationships") called "Related Change Info" with the following fields sets:

Applied to Table: change_request
Queries from Table: u_my_table

What do I need to put in the "Query with" area to ensure that only the rows I create by pressing the "New" UI Action button on the "u_my_table" related list associated with a change_request record show up for this change_request record and not every change request record. Thus far, my experiments have yielded results that either show the same u_my_table record entry in every change_request related list area or in none of them.

[richard_selby]

Actually, then I noticed it's even easier. As soon as an Incident is linked to a Problem, Incidents show up on the related lists for the problem. Then by right clicking on the Incident related list, personalise layout, and select CI. Don't even need to enter a new relationship. But interesting to learn more about how they work.

[Mark Stanger]

That will show you the single 'Configuration item' listed on the incident form, but it doesn't show you the entire 'Affected CIs' related list from the incident record. I think you're still better off with the defined related list because you get the entire picture, not just the primary CI from the incident.

[cdgaefke]

I created two tables from scratch. I created a relationship. If I manually add a record to table #1 referencing #2, it shows up in the embedded list when displaying the records in table #2. However I'm not able to add any new records to the list, which is precisely what I'm trying to accomplish. When I say "not able to", there isn't a new button, nor is there an "insert a new row" field.

I'm trying to accomplish what appears to be working correctly in the wiki example to add the approvers list to the change request form. I'm at a loss as to what I'm missing.

How to make an embedded list

Thanks.

[Ryan_Gillespie]

In the column headers, right-click and then choose Configure > List Control and you should see options there to enable the ability to create new and list edit insert row.