I have two text fields. One field has drop down options. The following field I want to update with a text string depending on the selection of the previous field.
As an example:
I select 'Apples' from the drop down field. The field below returns 'Fruit'.
I want this as a calculation rather than a relationship query.