result of select command into combox in ax

hi all,

I have a combo box and i want to write a select command and fill data to combo box

please guidance me

thanks

Please elaborate your requirement

Hi,

Kindly give the detailed info … Here is one example with what i have understood on ur query.

Select forupdate yourtable where ( give the req condition);

yourtable.combofield = yourtableenumtyp::selection;

yourtable.update();

Thats al…

Thanks and regrads,

Kevin

Why do you specifically want it to be a combo box and not a standard lookup?

SysTableLookup class could display something based on a query

Global::pickList() is an example of showing a list of elements in a different way, which can give you another perspective.

THANKS ALL,

i want to click button and filter combobox automatically

for example with click just select number assement_id==2

THANKS ALL,

i want to click button and filter combobox automatically

for example with click just select number assem

0284.1.bmp (164 KB)

Then it’s not really a combo box in AX terms. just a normal lookup

and that’s why you should look for example of using SysTableLookup class

hi kashpeuk

thanks for guidance

i have two sys table lookup i want when a lookup change text other lookup filter whit selected lookup value

like this :

6332.jsss.jpg

Hello JM,

In the second lookup method, pass the value of the first control value in the queryBuildRange.So it filters the records based on the first control.
let say, in the 2nd control of the lookup method
qbr.value('Pass the first control<Assement_id>).