Hi, everyone
I have a form with two datasources (ProjTable and projDetail the relation between them is Projtable.ProjId == ProjDetail.Projid)
I have a grid based on ProjTable, and I need to show only the projects that exists in ProjDetail
how can I do that
thank for all
This should work without having to do anything if the correct relations have been added to the table in question. Is the relation on the table? Check the "Join Source" property of the form datasource of the table in question on the form as well.
Alternatively, if you want to set a filter on the datasource, that can be done in the excuteQuery method of the datasource (before the super call). Get the QueryBuildDataSource object from the query and set the filter.
Hi, As Anton mentioned, it can be done by setting form datasource relations correctly. Check JoinSource property in ProjDetail datasource. You can refer to SalesTable form and refer to SalesLine datasource properties.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader