Microsoft Dynamics AX (Archived)

How to select value from combo box to textbox

(0) Share

Report

Posted on by fajar

3,805

In form, I have combo box "List Milestone" and "Percent (%)"

If I click combo box, show "Name" and "Percent".

Example :

if I select one Name, so I get value for Percent in text "Percent (%)".

Please, help me.

Thank You.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Are these fields coming from a data source? If yes, you should look into the modifiedField() method that you can override on the table or on the datasource on the form

If the fields are unbound (not coming from a table in DB), you can override the modified() method on the combobox control, and retrieve the percent value based on the name.

Was this reply helpful? Yes No
fajar 3,805 on at

Like (0)

Report
Copy link

Link copied!

The field coming from method Lookup in another table.

Can you write the method sample for modified() or modifiedField().

Please..

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Here's an example of how the method would look if overridden on a new table that has 2 fields (ItemId and Field2):

public void modifiedFieldValue(FieldName _fieldName, int _arrayIndex = 1)

{

super(_fieldName, _arrayIndex);

switch (_fieldName)

{

case fieldStr(Table1, ItemId):

if (this.ItemId)

{

this.Field2 = InventTable::find(this.ItemId).grossVolume();

}

// This is optional, will immediately show the updated value on the form (otherwise, you need to tab off the field).

//if (this.dataSource())

//{

// this.dataSource().refresh();

//}

break;

}

}

Was this reply helpful? Yes No
fajar 3,805 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ivan.. I'm newbie.. so I confused.

I will explain...

I have table "PII_PercentageTmp" with field "Name" and "Percent".

And in Table "smmActivities", I create 2 field "Name" and "Percent".

And in form Hierarchy, in design, I create TabPage "Percentage of work Complete". I drag 2 field from smmActivities datasource.

Field "Name" and "Percent".

In field "Name", I create method Lookup for show data "Name" and "Percent" from table "PII_PercentageTmp".

And this code for Lookup.

public void lookup()
{
    SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tableNum(PII_PercentageTmp),this);

    Query                   query = new Query();
    QueryBuildDataSource    queryBuildDataSource = query.addDataSource(tableNum(PII_PercentageTmp));
    sysTableLookup.addLookupfield(fieldNum(PII_PercentageTmp, PII_Name));
    sysTableLookup.addLookupfield(fieldNum(PII_PercentageTmp, PII_Percent));

    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();

}

So, where I create the methods modified().

And, do you write that methods full?

Thank Ivan..

Was this reply helpful? Yes No
Verified answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Override the modifiedFieldValue method on smmActivities table

public void modifiedFieldValue(FieldName _fieldName, int _arrayIndex = 1)

{

super(_fieldName, _arrayIndex);

switch (_fieldName)

{

case fieldStr(SmmActivities, Name):

if (this.Name)

{

// This assumes you have a find method on the PII table, that searches by name.

this.Percent = PII_PercentageTmp::find(this.Name).PII_Percent;

}

// This is optional, will immediately show the updated value on the form (otherwise, you need to tab off the field).

//if (this.dataSource())

//{

// this.dataSource().refresh();

//}

break;

}

}

Was this reply helpful? Yes No
fajar 3,805 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ivan..

i get Error in "this.Percent = PII_PercentageTmp::find(this.Name).PII_Percent;"

Table PII_PercentageTmp not have class methods find.

" Find is not a class method "

What should i do Ivan?

Thanks..

Was this reply helpful? Yes No
Suggested answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Like I wrote in the above example as a comment, you need to create a method "find" on the PII_PercentageTmp table, that should look similar to any other find method on the other tables in AOT, and should search the record by name.

Was this reply helpful? Yes No
fajar 3,805 on at

Like (0)

Report
Copy link

Link copied!

This issue solved..

Thanks very much Kashperuk Ivan(Vanya)..

Was this reply helpful? Yes No