I don't know if it works but you can try this : Create 2 dataSources that points to the same table. Let's say the table name is YourTable. Create YourTable_Header and YourTable_Detail datasources. Like you probably already did, add filter on YourTable_Header to show only header. Then add a join relation between YourTable_Header and YourTable_Detail on the field that link the header to the detail.
Good luck! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, "Dimitri Dejonghe" <[EMAIL PROTECTED]> wrote: > > 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. >