How to add multiple columns from multiple tables in a view?

[Rajashree Patil]

Hi,

We have created a new reporting module in application menu. As we need to display multiple fields from multiple tables. (In module, Link type- List of records & Table - Selected a parent table)
It should display columns from 4 different tables.
In order to achieve this we have created one UI View, and in this UI view added other tables, from which columns to be displayed including Elements in that tables.

But still in view we can see fields from one table only(Which table is selected in module), "We need to display other fields also which are present in different related tables."

Can I get help on this? Attached some screenshots for reference, Kindly let me know if I am doing it in correct way or not.

Thanks in advance !!

[Aman Kumar S]

For these purposed, why don't you use database view, that should help you to achieve this requirement.

[Alex240]

Exactly, database views would achieve your porpoise. 

1. Create the database view containing the columns from all tables

2. Create simple report obtaining the data from the database view instead of the original tables