Is there any Function to automatically select a Value?

[microwin88x]

Hello! I have the following question:

Is there any way to automatically select a value from a field if I select another value from another field?

For example: I have fields like Zone and Office. 1 Zone has N Offices.

I want that if I select a particular Office, it automatically select the corresponding Zone.

I'm using the function ONLY (Zone) to get the corresponding Zone.

But I need to know if there's any way to select that Zone with a function...?

Thank you!!!

[chiru_thota]

Are you using a trigger to do this ?

=Concat(distinct Zone,',') will give you all Zones related selected offices

[Colin-Albert]

If your data model correctly associates the Zone and Office fields then there is nothing more to do.

Just add a listbox for Zone and another listbox for Office

Selecting an office will automatically indicate the associated zone via the green/white/grey logic.

Green shows the selected values and any associated values are white, unrelated data is grey.

[maxgro]

you can use field event trigger; you find it in

menu --> settings --> document properties --> triggers

and then

field events trigger --> on select --> add action --> select in field --> ......

but I think Albert solution is better