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)

Alex VN 1,994 on at

Like (0)

Report

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

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.
Suggested answer

GirishS 27,821 Super User 2024 Season 1 on at

Like (0)

Report

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

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.
Suggested answer

Mohit Rampal 12,554 Super User 2024 Season 1 on at

Like (0)

Report

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

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