[Axapta-Knowledge-Village] Re: Form with 2 grids and same datasource

2007-05-23 Thread Dimitri Dejonghe
Hi,

I tried that first, but finaly I have try to do it with a tempory
table. I fill the tempory table in for the detail grid and now it work
 without any problem.
But thank you for answering :)

Greetings

--- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert
[EMAIL PROTECTED] wrote:

 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 
 dimitri.dejonghe@ 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.
 





[Axapta-Knowledge-Village] Re: Form with 2 grids and same datasource

2007-05-22 Thread Steeve Gilbert
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.