Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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