I want to link a numeric and a text field such that a specific numeric value will trigger the display of a word.

Both fields are in the same table.

For example, in the table nobility anyone who is a one is a knight. Anyone who is a two is a baronet. Anyone who is a 3 is a baron etc.

A couple of options.

1) If the range of numbers is known, limited, and has a sequence.

TextField = Choose( NumberField ; "" ; "Knight" ; "Baronet" ; "Baron" ... )

* Choose() is a zero based index with 1000 repetions.

2) If the range of number is known and limited.

TextField = Case( NumberField = 1 ; "Knight" ; NumberField = 3 ; "Baron" ; "Default Text" )

3) Create a new table with all the combinations (or ranges of combinations) and use a Lookup.

* This may be be your best option for an expandable solution.

Edited May 17, 200619 yr by Guest

Thanks, Mark. Do I create all the combinations as records?

Here is a sample.

Feudal.zip