Connectred list box

[Anonymous]

Dear all,

is it possible to connect two listbox ?

Choosing a value into the first one, I would have the same value into the second:

For example I could choose October in the first listbox and the second one should have the same month.

Thanks for youe help

[simondachstr]

Depends - are you talking about two different fields which contain the same month? Like Sales_Year & Revenues_Year?

Then I suggest working with triggers. Choose 'Select Field', put in the name of your second listbox/field and in the selection box:
='=sum({<[Listbox2_fieldname]=[Listbox1_fieldname]>}1)'

Don't forget to include the same trigger 'On Change' if necessary.

Let me know if this helps you.

[Gysbert_Wassenaar · Accepted solution]

See attached example. See the actions on the OnSelect trigger of Field Prod1 to see how this is done.

[Anonymous]

Thanks !!!