Enter one value to display another

[bwill2000]

Hi All,

I am a newbie to Filemaker, only really know the basics. I am trying to do the following, but i do not know what the calculation is, if any:

A database with two fields:

Field 1 = Number

Field 2 = Name

I have a value list of 18 names.

When a number form 1 to 18 is eneted into field 1 (number) I need filemaker to automaticly enter a name from the value list into field 2.

Does anyone have any ideas? This is killing me.

Thanks All

[Lee Smith]

You have to hard code the calculation in Field 2.

The easiest way is via a Case Statement.

Case(Field 1 = 1, "Joe",

Field 1 = 2, "Bob",

Field 1 = 3, "Al"

)

and so on.

HTH

Lee