Field Activation

[Anonymous]

Hi All,

I have two fields one with Multi box (Flight Types) and the other with list box selection (Fligh Sub Types). When ever I select a value in Multi box the list box should get activated and should show me the corresponding values of list box (Flight sub types).

I will put it in other way,

I want to be able to do two things. 

    1.     When selecting one value in a particular multi box, it activates another list box near by.

    2.     When unselecting that value the list box should disappear

Is this possible in Macros or Triggers?  

I think we can use triggers for this but  dont know how and where to write this trigger.

Can any one help me how can i do this?

Rgds,

Nandha

[Gysbert_Wassenaar]

You don't need triggers. You can use the conditional display expressions you can enter on the Layout tab of the listbox properties windows. The expression you need is something like =if(getsubstringcount([Flight Types],'Additional'),1,0)

[Anonymous]

Thanks Wassenaar. But its giving me the list box if i select the first value. If i select the 2, 3, 4, etc., values the list box is not appearing.

Can you give me some ideas?

Rgds,

Nandha

[Gysbert_Wassenaar · Accepted solution]

If you want to check if any value is selected use getselectedcount([Flight Types]).

[Anonymous]

Thanks a ton Wassenaar.

I have one more query will the list values disappear when I do no selection in the multi box? I mean when ever there is no selection in multi box list box should appear (heading, scroll bars and led of the list box) but the list values (names of the company) should not appear . If i select some value value in multi box the list values (names of the company) should appear in the list box.

Rgds,

Nandha

[Gysbert_Wassenaar]

Yes, the listboxes are hidden until you select values. That's what you asked for in your first post:

When unselecting that value the list box should disappear

If you want empty listboxes to be shown then the easiest way is use table boxes instead and make them look like listboxes.

[Anonymous]

Thnx for your quick reply.

Do you have any example QVW fo this?

[Gysbert_Wassenaar]

Hmm, listboxes can't be made empty easily so I had to use straight tables. See attached qvw.

[Anonymous]

Sorry Wassenaar.

Have youcalled te same value both in Multi and list box (Straight Table)?

I have attached my scenario here pls help me

Rgds,

Nandha

[Gysbert_Wassenaar]

Same principle, just replace the field name to what you want to show. See attached qvw.