Multiple Data Sources. 1 GRID HELP

(0) Share

Report

Posted on by Community Member

Hello guys, im facing a problem.

i have a form, inside that form there is a grid with a number of fields(CustTrans.PaymMode,CustPaymModeTable.Name,GeneralJournalEntry.DocumentDate,GeneralJournalAccountEntry.CurrencyCode, etc )

as you can see i take values from a number of tables. but in the grid control i can only set one datasource.

¿how can i make the query that relates everything i need from those tables and populate the grid in response to that query?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

You need to join all data sources in question together. What you'll set to grid's DataSource property is the root data source.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks a lot. so i ll start from CustTrans(Using account numb, a custom field, and PaymMode), join the query to the other tables. is this correct?

where i write the query? ( overriten executyQuery method or what?)

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

I can't tell what tables should be in your query, because I don't know what you're trying to achieve.

How to join data sources is explained in How to: Join Data Sources for a Form.

You should use the documentation that Microsoft prepared for you; it will answer many of questions of yours.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

If you are using a list page template then you have to make an AOT query and join all tables, but if you are using any other type of form then what you need to do is set a main datasource(CustTable) and then go to form => go to each required datasources =>select join source (CustTable) and select Link type=> outerJoin

Now select main datasource(CustTable) as datasource of the grid, now you can add all tables field in that grid. Please tell me if you are facing any issue.

Was this reply helpful? Yes No