Other select option?

Hi! I’m making a database for me to keep track of my train delays and the compensations I need to request, have requested and are approved or declined.

I like to have an overview of the route I took. For this, I have two fields:

  1. Departure train station
  2. Arrival train station

Both have these two options in a single select:

  1. Antwerpen-Centraal
  2. Noorderkempen

Basically I want to only select the departure train station, and the formula should put the other option in the arrival train station. For example if I select “Noorderkempen”, the arrival train station should be set to “Antwerpen centraal”.

How would I achieve that? Thanks in advance!

The {Arrival Station} field could be a formula field with this formula:

SWITCH(
   {Departure train station},
   "Antwerpen-Centraal", "Noorderkempen",
   "Noorderkempen", "Antwerpen-Centraal"
)
1 Like