Is conditional "Select in Field" possible?

[sifatnabil]

Hi all,

I want to select a field value in a list box, which should then auto-select another associated field  and value. But can the value of the trigger field be specified and triggered upon?

I want to select "Asia Forwards Trader" in field [Record Type] only if the trigger field Market='Asia NDF'. I tried putting if(Market='Asia NDF',[Record Type]) in the Field box below but it doesn't work.

Any help would be greatly appreciated, thanks!

[nagaiank · Accepted solution]

You may not be able to select a fieldname in the Field box. But you set value in the Selection Box based on any condition.

See if the attached example gives you any clue.

[sifatnabil]

Thanks - I believe this is not possible to do.