Hello

I am a very basic Crystal Reports user and I need to do something that seems like it would be easy.  I can't figure out how to do it however.

I have a field in the database that has a code in it.  I need to take that code and use it in another created field so that has a translation for the code is displayed when the report is exported.  Here is what I have:

Field1 = Field in the database, has a code as text
Field2 = Created field that is not in the database and is variable

What I want to do:

If {table.Field1} = "A172" then {Field2} = "dogs"
else if {table.Field1} = "R175" then {Field2} = "cats"
etc. etc.

I just do not know how to create Field2 and I do not know where to put the code to do this.  I am not even sure if this is the best way to do this or if it is even doable.

Any help would be greatly appreciated.

Thank You

Thank you very much I think that is exactly what I needed.