Microsoft Dynamics AX (Archived)

Dialog Field Enum lookup value based on another Enum in AX 2012

(1) Share

Report

Posted on by Karthik Desappan

5,680

Hi all,

I need information from lookup in AX 2012 dialog form.

I have already familiar about normal lookup in ax 2012.but I need some different concept from dialog lookup concept:

my requirement is I have two combo box in dialog form when I select first Enum field value second Enum field lookup based on first Enum field..

for example,

Combo box A Enum:

0: Food

1: Fruit

Combo box B Enum(In Total):

0: Rice

1: Noodle

2: Apple

3: Orange

in dialog form select Enum A value is Food,

Enum B value lookup based on Enum A value: Lookup value Rice, Noodle

in dialog form select Enum A value is Fruit,

Enum B value lookup based on Enum A value: Lookup value Apple, Orange

if anyone already done this plz let me know........

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

And where you define the relation between those two data sets, e.g. that Apple is a Fruit?

A table with two columns is the usual choice. Consequently, you'll be able to use a normal lookup.

Was this reply helpful? Yes No
Karthik Desappan 5,680 on at

Like (0)

Report

Hi martin,

That is what I am I asking the query because how AOT enums are related in dialog field lookup based on one from another, in a run base dialog using two enum above I explained these are normally independent in enum node in the aot. But I need to be do generally done in what normally lookup in a dialog.....

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Enums are just lists of values. If you want to make a relation between two enums, you have to implement it by yourself. And as I already said, a table is usually the most appropriate mean for implementing such a relation.

Was this reply helpful? Yes No
Suggested answer

Ivan (Vanya) Kashperuk on at

Like (0)

Report

I will also just drop it in here, that enums in AX are limited to 255 values.

Your EnumB sounds like it might easily exceed that, so maybe you are better of with a table for this, not just the relationship?

Was this reply helpful? Yes No
Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

As Martin and Ivan suggested this requirement can only be implemented or can best be implemented by using tables where you can define relations between these two lists. Otherwise you really have to handle this with many lines of code which could lead to performance on dialog box.

Was this reply helpful? Yes No
Karthik Desappan 5,680 on at

Like (0)

Report

Hi faisal,

thanks for your replies..

if u have any xpo or document about this task related share me..

I don't know how to start without relationship of in the table for two list to done in the dialog form.

Was this reply helpful? Yes No
Suggested answer

Mohammad Raziq Ali 2,486 on at

Like (0)

Report

Hi,

It is just for your reference on how to add combo box on runbase dialog form.

Please follow my blog https://mfmujahidmim.wordpress.com/2015/01/16/how-to-add-combo-box-on-runbase-dialog/

thanks,

Raziq

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

AX is full of such examples; it's what relational databases are all about.

Simply create a new table with tho fields, one holding the identification of the item (Rice, Appl

e etc.) and one the category (Fruit, Food).

Then you'll simply filter by the category in your lookup.

Was this reply helpful? Yes No