Question about field text calculation

Discussion created by D.S. on Aug 23, 2017
Latest reply on Aug 27, 2017 by fmpdude

Hi there


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.


Help? Cheers!