I need to create trigger to select value in one field I choose value in the other field.
I have field "Country" with values:
An the other field "City" with values: Paris,
Frankfurt am Main,
When I select France I need an auto-select France city that will be first in alphabetical order. So it will be Marseille But also I need to have a possibility to make manually selection of the other city for selected country.