How to create relationship between two table?

[rojerio]

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

Thanks in advance.

[sachin_namjoshi]

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

[Ashutosh Munot1]

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

[Bhagyashri Sort]

Hi,

Refer below link.

Two Table Relationship

Mark it Correct or Helpful.

Thanks

Bhagyashri Sorte.

[Onkar Pandav]

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.