question Re: Create One to Many Relationship in ITSM forum

Create One to Many Relationship

sushil sinha — Wed, 29 Aug 2018 11:05:50 GMT

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

Re: Create One to Many Relationship

Mark Stanger — Wed, 29 Aug 2018 11:07:49 GMT

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.

Re: Create One to Many Relationship

sushil sinha — Wed, 29 Aug 2018 11:12:05 GMT

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.

Re: Create One to Many Relationship

Mark Stanger — Wed, 29 Aug 2018 11:16:55 GMT

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.

Re: Create One to Many Relationship

sushil sinha — Wed, 29 Aug 2018 13:13:01 GMT

Thanks Mark.

Re: Create One to Many Relationship

Mark Stanger — Wed, 29 Aug 2018 13:29:59 GMT

You're welcome!