Create One to Many Relationship

[sushil sinha]

Hi,

I have to create one to many relationship .

I can do many to many but I don't know how to configure one to one, and one to many relationship.

Thanks in Advance.

Sushil

[Mark Stanger]

A one-to-many relationship is created just by adding a new Reference field to a table.  The reference field is the 'One' end and the associated related list on the other end is the 'Many'.

ServiceNow does not have a concept of a 'One to One' relationship.

[sushil sinha]

Hi Mark,

I have to create like change_request and change_task.

Like one change_request having multiple change_task record.

Please find the below screen shot.

[Mark Stanger · Accepted solution]

Okay, so in that situation the one-to-many relationship is created by adding a 'Change request' reference field on the 'Change task' table.  You can see the field if you open a change task record.  You can also identify the field in your screen shot filter above the 'Change tasks' related list where it says 'Change request = '.  This part of your filter isn't editable because it is the relationship field that ties those 2 tables together.  The 'Change Tasks' related list is created at the same time as the 'Change request' field to complete the 'Many' side of the relationship.

If you want a new 'One-to-many' relationship between 2 tables you just need to create a new Reference field on one table and then add the related list on the other.

[sushil sinha]

Thanks Mark.