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
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.
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.
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156