Look up with data from two fields

Finance and Operations/AX Developer Forum
1

Hi Friends,

I have small Doubt .Please look into the Following

I have one table(Table1) having two fields like Field1 and Field2.

My Requirement is .

i want to show the Look up of two fields of data into single Lookup Fields

Ex: Field1 having the data like 1,2,3

Fields2 haing the data like 4,5,6.

so then i want show the data of two fieds into single lookup fields data

lokkup contains 1,2,3,4,5,6 in single lookup fields

thansk in advance

Murali.

2

Use a union query, if you version of AX supports that.

Please always attach a tag with your version of AX; it’s in your own interest.

3

Hi martin,

I am using the Ax 2009.

Thanks for reply…But union is used two different data sources .

here i have only one data source and two fields so how i will use the Union for this…

4

It uses two data sources, but nothing prevents you from using the same table in two data sources. Using pseudocode, your requirement looks like this:

select Field1 from Table1
union
select Field2 from Table1
5

Hi martin,

Thnaks for reply…that is ok but i want to show lookup by using the Queries .

can u help me that?

Thanks in advance,

Murali

6

Sorry, I don’t understand what you mean by “to show lookup by using the Queries”. Could you explain your problem in better details?

7

Hi martin,

Actually i have Form and Adding the new Field.

I want to show the Lookup in that field which it requires data of other table of two fields data…

Ex: table contains Two fields like field1 and field2.field1 having the data 1,2,3 and field2 haing the data 4,5,6 then

Fielld 1 / Fielld2

1 4

2 5

3 6

In the Lookup i want to show one column and these total data like 1,2,3,4,5,6

Thanks in advance,

Murali

8

Yes, I thought that’s already answered. What’s the problem?

By the way, I suspect that the requirement is actually a sign of wrong database design (but I don’t know your particular situation, of course).