Auto filling fields based on another field
I have another question. Is it possible to have a field autofill based on a different field? For example, There are two fields; one called fruit another called color. If the data in the fruit field = strawberry can the color in the other field auto populate with "red"? If the data in the fruit field = "banana" then the color field will auto fill "yellow", etc......?