Combine multiple tables

[Community Alums]

Hello all, 

There may be a another way to do this so I may be making it more complicated than it needs to be.

I have a requirement where I need a single view of the below tables which can be used in a reference field and within related list.

• Incident
• Change
• Problem
• Risk
• Issue
• Project Task

[Dr Atul G- LNG]

Hi @Community Alums 

Is these all tables extended from Task ,then youse task table as reference. What is your use case to combine all these.

[Community Alums]

I didnt note it but I do need to add 2 additional custom tables which are not part of the TASK table lets just call them u_one and u_two

[Dr Atul G- LNG]

Hi @Community Alums 

https://www.servicenow.com/community/developer-forum/how-to-reference-field-with-multiple-tables/m-p/1512983/page/2