Selecting in a list box using another list box

[ahammadshafi]

Dear Experts:

In the original client source file there are 6 currencies - they are populated in a list box; named "Currency". But the client wants that users will have another list box (named "InLineCurrency") which will have a fixed sub set of the 6 currencies and a new one named "LC" (Local Currency).

The requirement:

1. If the user selects "LC" from "InLineCurrency" no item will be selected in "Currency" listbox.

2. If the user selects "USD" from "InLineCurrency", "USD" will be selected in "Currency" listbox.

Please find a sample QVW file as attachment.

Regards,

Shafi

[adamdavi3s]

Hi Shafi,

I would probably use a field trigger for this.

I will make an example.

[ahammadshafi]

Hi Adam:

I am looking forward to the example; thanks.

Shafi

[adamdavi3s]

Here you go, You could also use different formula to do this if you wanted e.g if selection = LC select nothing, else select InLineCurrency as they are the same

[adamdavi3s · Accepted solution]

Ok here is an example with the IF as well, which will obviously improve things if you want to add more to your inline.

Note that we use actions on both the select AND on change to handle this.

And these are in settings > document properties > triggers, in case you haven't used them before.

[ahammadshafi]

Hi Adam:

Many thanks. You are absolutely right, I didn't use field trigger before.

Shafi

[tamilarasu]

Hui Ahammad,

You can simply try like below screenshot.

[adamdavi3s]

No problem, they're very useful but a pain when you're debugging and forget that they are there!

[ahammadshafi]

Many thanks Nagaraj.

That's an even better solution ...

[ahammadshafi]

Many thanks Adam for mentioning it.