Expression list box selection

[Leo2]

Dear community!

I've got kind of such data model:

Person,Type,Event

Person1,1,Event1

Person2,1,Event1

Person1,2,Null

In front end I've got 2 list boxes. The first one is 'Event'. The second is with the expression =if(Type=2,Person)

Any ideas how to connect Event and Person fields? So technically I need field Person to get selected (regardless of Type) when the corresponding value selected in the expression list box (=if(Type=2,Person)). And vice versa - if a field selected in Event list box I'd like to see corresponding values highlighted in expression list box. Could anyone help please?

[richard_chilvers]

Hi

I'm not entirely sure what your requirement is.

However, in my experience, list boxes which use an experssion are not ideal.

I would suggest you try creating a new field which is populated from existing data but only for records you want to appear in that list box.

HTH