Hi All
when user select :-
BRAND_P=BECKHOFF , PRICELIST to display EURO123
BRAND_P=GE , PRICELIST to display USD123
BRAND_P=HAKKO , PRICELIST to display USD123
BRAND_P=MITSUBISHI , PRICELIST to display SGD123
Right now my Script is below :-
left join (PRICE)
Load PART_NO_,
'USD '& LIST_PRICE as PRICELIST
Resident PRICE;
it make all PRICLIST filed fill with USD.
I like Pick and match , so i try it but cannot work , may be i need to add more code :-
Pick(Match(BRAND_P,'BECKHOFF','GE','HAKKO','MITSUBISHI'),'EURO','USA','USA,'SGD')& LIST_PRICE as PRICELIST