Finance | Project Operations, Human Resources, ...

Add fields from multiple data sources to the same grid control in a form

(0) Share

Report

Posted on by arai

I have added two tables as data sources in a form. Now I want to add the fields from both the tables (data sources) in the grid control of the form. How do I achieve this since in the data source property of the form grid control, we can add only one table/data source at a time.

Thanks and Regards.

All responses (3)

Answers (0)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Arai, Check these threads. Also You can check standard forms for reference

community.dynamics.com/.../377192

community.dynamics.com/.../how-to-link-multiple-data-source-and-use-in-list-page-grid-in-an-extended-form
Suggested answer

GirishS 27,845 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi arai,

Since you have added join source property on the DataSource, I think it will show the field values even its from different tables.

So, you can set the Grid DataSource property to the main DataSource and add fields from both the tables and try.

Thanks,

Girish S.
Alex VN 1,994 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you already make the linkage between datasources, then you can just simple add the field on the grid as the field has it own datasource. The datasource property of the grid mostly to determine the main ds for the grid.