Announcements
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 345 Most Valuable Professional
CU10121822-0 304
André Arnaud de Cal... 283 Super User 2026 Season 2
