Microsoft Dynamics AX (Archived)

How i can set a value of specific column in a lookup?

(0) Share

Report

Posted on by ismaelivan

578

Good day, I want to get the value of column 3 (MainAccountId)

when selecting the line.

I get the lookup con this code...

    SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(NumberSequenceGroup), this);


    sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, NumberSequenceGroupId));
    sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, Description));
    sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, MainAccountId));


    queryBuildDataSource = query.addDataSource(tableNum(NumberSequenceGroup));


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

Thanks in advance!!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

shariff 20 on at

Like (1)

Report
Copy link

Link copied!

Try adding range on the query

qbds = query.addDatasource(Tablenum(tablename));

qbr = qbds.addrange(fieldnum(tablename,MainAccountID);

qbr.value(queryvalue(value));

Was this reply helpful? Yes No
Suggested answer

Anton Venter 20,678 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Because the SysTableLookup class uses the first column as the selection return field, you have to set MainAccountId as the first field/column in the lookup. If you don't want to have the MainAccountId as the first column, create your own lookup form. See www.axaptapedia.com/Lookup_Form on how to do that or search the internet. The code example in the Axaptapedia article is old but will probably still work fine.

Was this reply helpful? Yes No
Karthickks 100 on at

Like (1)

Report
Copy link

Link copied!

Hi ismaelivan,

As per my understanding you need to select mainAccountId in your form control. Please use below modified code.

sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, MainAccountId));

sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, NumberSequenceGroupId));

sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, Description));

This will work as per your requirement

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,208 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I think this should be sufficient:

sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, NumberSequenceGroupId)); sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, Description)); sysTableLookup.addLookupField(fieldNum(NumberSequenceGroup, MainAccountId), true);

Notice the additional parameter on the last line.

Was this reply helpful? Yes No