Form with 2 grids and same datasource

speedyken

Hi,

I try to make a form with 2 grids (Heading grid an Detail grid) that have the same datasource but with other fields of the table used.
The table contains header records and detail records and are marked in a field that contains the number 1 or 2.
This field is related with a field called DocuNumber.

Now, On my form the heading record works correctly but I don't find it how I can show the details in the detail grid. I Know that I have to use the active method in the heading grid to change data in de detail grid when select an onther record. But I don't know what code I could use so that I get the correct data in the detail grid.

Thans on advance.

burdee64

Hi,

The answer isn't that difficult.
You need two datasources referring to the same table:
example: headerTable and detailTable.
In the active() method for the first datasource (headerTable) you call

detailTable_ds.executeQuery();

In the executeQuery() method of detailTable you can set the correct selection (addRange, findRange) for this second grid.
Values from headerTable can be used to set these ranges here.

Try it out, i'm doing things like these all the time.

If I havent been clear enough mail me ....

Bert van Dijk

speedyken

Hi,

thank you for you're answer. But I had already tried it with an tempory table and it works without any problem. The next time or when I have a little bit time I will try it on you're way

Greetings