[Axapta-Knowledge-Village] Row X of Y

[Dimitri Dejonghe]

Hi,

I know how you can get te total amount of rows in a grid.
But how can jou get the rownumber that is selected.

Below the grid should come:

row X of Y.

thanks

[Axapta-Knowledge-Village] sorting dropdownlist

[Dimitri Dejonghe]

Hi,
I have added a lookup field to the busreltable and now I want to sort
that field:
The lookup on the field is on runtime.







[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] sorting dropdownlist

[Dimitri Dejonghe]

hi,

I have added a field to the form smmbusreltable. Now I want to sort that
field.
2 printscreens can be found here with the problem:
http://www.geocities.com/dimitridejonghe/sort.jpg
http://www.geocities.com/dimitridejonghe/sort2.jpg

Thank you on advance

[Axapta-Knowledge-Village] Re: sorting dropdownlist

[Dimitri Dejonghe]

Hi,

I solved this problem myself.

If anyone has such a problem, use this code in the lookup method on
the lookup field:

public void lookup()
{
SysTableLookup  tableLookup;
Query   query;
QueryBuildDataSourceqbdDs;
;

query = new Query();
qbdDs = query.addDataSource(tablenum('TABLE'));
qbdDs.addSortField(fieldnum(TABLE, FIELD));

tableLookup = SystableLookup::newParameters(tablenum(TABLE), this);
tableLookup.addLookupfield(fieldnum(TABLE, FIELD));

tableLookup.parmQuery(query);

tableLookup.performFormLookup();
}

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

[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] Form with 2 grids and same datasource

[Dimitri Dejonghe]

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] Document Handling

[Dimitri Dejonghe]

Hi,

In Axapta there is a form smmDocuments that is uses on CRM --
Business Relations and click there on the button Documents.
Here you can add files to a Business Relation.

Now, there is an other form DocView that you can call from any form in
the toolbar. On this form you can ad a document to a record that has
been selected when you clicked this button.

Now is my question:
On smmDocuments you have an ActiveX control where you just have to put
the file on that button and it's imported in a record.

Is this possible to insert this ActiveX control in the Docview form
and let it work?

Greetings.