Calculating field

[carol.ruth]

I am new at this!! I am trying to create a database where if I type a code into one field, a statement appears in another field. Example: if I type BE3 in one field, the statement "Is very well behaved!" will automatically appear in another field. I don't know where to begin with this. Can anyone help me?

[Kurt Knippel]

The second field would be a calculation. Such as:

CASE ( FirstField = "BE3", "Is very well behaved", "" )