How to create relationship between 3 tables ?

[Servicenow lear]

We have a requirement to have 3 tables data visible as a related list.

How to achieve this ?

[AndersBGS]

Hi @Servicenow lear ,

if you would like the three table combined and showed as a related list, you should first create a database view to combine the three tables. Afterwards go to relationship and create the relationship between the parent table and the new database view. Post these activities, you can add the related list on the form.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Abhilasha5]

Hi AndersBGS  

I have created database view for 3 tables, but while creating relationship what to write in query..? Can you please provide example.?

[AndersBGS]

Hi @Abhilasha5 

Go to the relationship table and explore what is already there OOTB. This will be the easiest to actually learn what to write in the query. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[AndersBGS]

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders