when user select Currency_P=SG , How to automatic activated TRANSPORT=VLO=1

[#1]

Hi All

I created 2 inline load script as below :-

TRANSPORT:

LOAD * INLINE

TRANSPORT, TRANSPORT_SUB

HI=1.2,1.2

MID=1.1,1.1

LO=1.05,1.05

VLO=1,1

];

RATE:

LOAD * INLINE [

Currency_P, RATE_P

SG, 1

MY, 2.6

INDO, 8800

THAI, 25

];

My question is , can i achieve this :-

if user select SG , i want to force Transport = VLO=1

Other then above , user are allow to change TRANSPORT to any value.

May i know how to achieve this ?

Paul

[simondachstr]

Have you tried working with field event triggers?

Document Properties -> Triggers -> Field Event Triggers -> OnSelect -> Add Action(s).

[#3 · Accepted solution]

Hi Paul,

Use Triggers like said Martin.

Document Properties -> Triggers -> Field Event Triggers -> OnSelect -> Add Action(s)

click On Currency_P -> Edit Actions -> Add -> select a field ->

Field :

TRANSPORT

Caracteres:

VLO=1

Click Ok (x2)

When you select SG , VLO=1 is selected. 

[#4]

Hi Jud

Many thank for your detail explanation , yes it work fine .

Paul

[tresesco]

I think, if your selection is based on the condition (Currency_P=SG), your search string shoud be:

=If(Currency_P='SG', 'VLO=1')

Otherwise, it will get selected for any selection in the Currency_P field. Isn't it so?

[Anonymous]

Hi,

You can join the 2 tables like this:

RATE:

LOAD * INLINE [

Currency_P, RATE_P, TRANSPORT

SG, 1, VLO=1

MY, 2.6,

INDO, 8800,

THAI, 25,

];

Then you'll have you field TRANSPORT joined to the table RATE with the value SG, 1 <=> TRANSPORT, VLO=1

[#7]

Hi Tres

Your proposal work fine when user select SG , it will set transport to VLO=1 , yes this is what i want.

However when user change from SG to other , the transport will not be selected. which is not what i want.

I need the transport to stay at VLO=1.

As my criteria happen to be when user select i must make transport set at VLO=1 , for other user can make changes.

( This is because my pricing cal approach )

Paul

[#8]

Hi Bob

Your approach is not work for my situation, As for initial selection , i happen need to set the TRANSPORT = VLO=1

and when user change to other then SG , user are allow to change the TRANSPORT to other value.

Your approach is fix , for SG = VLO=1 ... as i also allow user to change to other value.

Thank you any way,

[tresesco]

So the solution above is what you want. right? Sorry, i misunderstood.

[#10]

Hi Tres

Thank you for your help.away.

Paul Yeo

Skype paulyeo_thai