Hi. I want to create a form showing 2 grids...one with headers (more than one) and one for the lines related to the selected Header.
For some reasons, and I cannot find the reason why, I see only one Header and the wrong related line.
I do have a relation on the LinesTable to the RecId of the Header. In the form I set the JoinSource Option on the LinesTable to the HeaderTable
What am I doing wrong?
*This post is locked for comments
Thx Martin I did not recognize even with double-check the values that I selected the LinesTable in Header Grid
Make sure that the child datasource is linked with a Delayed link and that both grids have the right value in their Datasource property.
Hi André
Well on the LinesTable I have a field Holding the RecId of the Header. This field is set up as Relation:
The Relation Properties are the following:
On the Formdatasource for the line I set the JoinDataSource Property to the Header datasource
Hi Chris,
Which datasources are set on the grid properties. Are these correct?
Can you probably share step by step or with a screenshot how you created the relation and did the setup of the JoinSource on the form?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156