question Re: How to create relationship between two table? in ITSM forum

How to create relationship between two table?

rojerio — Wed, 06 May 2020 19:09:01 GMT

I have two table A, B and i want to make report based on their relationship how to do?

Thanks in advance.

Re: How to create relationship between two table?

sachin_namjoshi — Wed, 06 May 2020 19:11:17 GMT

You can create reference field on either tables to point to another table.

This will allow you to create relationship between 2 tables.

Regards,

Sachin

Re: How to create relationship between two table?

Ashutosh Munot1 — Wed, 06 May 2020 19:17:34 GMT

Hi,

What is your exact Business use case? As sachin said you can do that or else we need to create custom relationships.

Thanks,
Ashutosh

Re: How to create relationship between two table?

Bhagyashri Sort — Thu, 07 May 2020 04:43:44 GMT

Hi,

Refer below link.

Two Table Relationship

Mark it Correct or Helpful.

Thanks

Bhagyashri Sorte.

Re: How to create relationship between two table?

Onkar Pandav — Thu, 07 May 2020 05:41:57 GMT

Just want to add here.

A Parent-Child relationship can be created by adding a reference field, that references the parent table on the child table. Same like OOB Change and Change Task relationship.

It can be created by adding a reference field on the child table and then you will find that relationship in the related list (right click->configure-> related list) of that parent table, from where you can add it to the form.

If there is a requirement for a child to have more than one parent, then you have to create a many-to-many relationship.

Re: How to create relationship between two table?

S M — Thu, 06 Oct 2022 15:54:32 GMT

Hello Tera,

In order to create a report on 2 tables, you can create a Database view and set the where to the common field.

Best wishes,

Shay

Re: How to create relationship between two table?

Patrick Laroch1 — Thu, 06 Oct 2022 18:51:30 GMT

You can also create a database view and create your report on it.