How to pass a selection to another field

[hopkinsc]

Hi,

I am trying to set up a trigger to pass a selection from [Operative Region] and put it onto [Order Region] so the outcome would be i would have the same selection in both fields.

The fields are not linked which is why i wanted to do it this way.

Thanks

[#2]

Hi hopkinsc,

     If [Operative Region] and [Order Region] have the same values in some cases you can use a set analisys expresion using = operator like that [Order Region] = {$([Operative Region])}

I hope to help you.

[jagan]

Hi,

Check attached document for solution.  To do this you need to add trigger for the field, I added the trigger for field by doing the following steps.

Document Properties -> Triggers -> Field Event Triggers -> Select Field -> On Select Add Action -> Add -> Selection -> Select in Field

Hope this helps you.

Regards,

Jagan.

[hopkinsc]

Hi This works, but it will only work if the data selected have no spaces in the text.

For example...

The fields contain region names..

East

West

Scotland

Outer London

Central London

North East

North West

etc

the East, West and Scotland work, but it won't pass any details across for the others.

Does anyone one how to overcome this?

Thanks

[giakoum · Accepted solution]

replace the search string with exactly this :

='=sum({<F2=F1>} 1)'

[jagan]

It works.  Check attached file.

Regards,

Jagan.

[giakoum]

dont ask why it works...