Form with table relations

Hello,

I have a form containing 3 different DS:

Transmission, DocHeaders, DocLines

The table DocHeaders has relation to Transmission (1 Transmission to N DocHeaders)

DocLines has relation to DocHeaders (1 doclines to N docheaders)

The form has a first tabpage with a transmission grid.

Has a 2nd tab page containing DocHeaders on the top, and DocLines on the bottom (a kind of salestable model)

Datasources are properly linked (docheader to transmission, doclines to docheader) with delay method

When I select a transmission in the 1st grid and select the 2nd tabpage I have the following problem in the 2nd grid:

  • the focus is on the same grid line as the 1st grid (i would focus on the 1st docheaders) even if the grid line doesn’t contain any data

  • I can see doclines only when press F5

any suggestion? form to reference ?

thx

errata corrige: DocLines has relation to DocHeaders (1 docheaders to N doclines )

What is the join type between the data sources? it should be ‘Active’

and check whether the data source property of each grid set to corresponding tables.

-Arun.

may the problem with data source relation type. it should be Active.

or else, try to write a piece of code like YourDataSourceName_ds.research()

YourDataSourceName_ds.refresh() in appropriate mehod.

Hi Pixie check design → grids–> prop–> datasource names.

  1. Are you using splitter form for TabPage2.

Thanks

Ravi