two tables fields to display in a one report for Dashboard

Kri
Tera Guru

I have 2 tables which contains different fields but I want to merge them in a single report and display it as a dashboard

 

table1 - field1, field2

table2 - field3, field4

5 REPLIES 5

Renat Akhmedov
Tera Contributor

I see two solutions here:

1. Do it with System Definition -> Database Views, here is a good tutorial for this. 
2. Add two reference fields from one table to another, in conclusion, you will have 4 fields available in one table, and use this table for the report, gauge, and dashboard. (doggy solution, please don't do this).


I would solve it with a database view, obviously.

If it helped you somehow, please don't forget to mark it as help, if not - sorry, I tried.