Database View Reporting

[AllenJaikkA]

Hello Everyone, 
I have this requirement to merge Task and Interaction Table. I had successfully created a database view using task, interactions and interaction related record table. My problem is to combine the task.number and interaction.number field into one unified field. One of the goal is a single report that will show task and interactions that is worked on by a specific team. Thank you so much. 

[Ankur Bawiskar]

@AllenJaikkA 

not possible as both tables have number field

they will be shown as separate ones in reporting.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏