Value list based on two fields?

[Mazkot]

I have a form which has two seperate fields ( Fruit1 & Fruit2) and I would like to create a value list to show both fields...for example:

 

Fruit1 might have values of Apples, Banana, Grape

Fruit2 has values of Lemon, Mango

 

 

I want a value list when the field is selected to show all 5 as a selection:

 

Apples

Banana

Grape

Lemon

Mango

 

Any thoughts? 

[eos]

Create your value list from a calculation field List ( fruit1 ; fruit2 ), result type Text.

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Pro 12" to "Value Lists".

 

The general topic areas are reserved for the discussion of the new tools, functions, and features that were introduced with that version of FileMaker, not for asking how-to questions.

 

If you have any questions about this action, please contact me by Private Message.

 

Lee