Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Create One to Many Relationship

sushil sinha
Giga Contributor

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

1 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.

View solution in original post

5 REPLIES 5

You're welcome!