Sorry, If this has been posted a hundred times,

My brains hurting as I've been having loads of fun with FileMaker 7, understanding the new fundamentals. Im trying to rebuild an existing application that I've built with v6 as I think this is the best approach for me - converting was a real nightware.

Anyway, I have created a text field called Type, and the user enters data into it via a value list popup.

the valuelist contains for e.g. cat,dog,mouse etc, Is there a way I can enter Cat, but the value that is stored in my Type field is "C" (i.e. the first letter of the value for my selection. )

Thanking all in advance.

Jalz

Do an auto-enter calculation, with Left ( Type ; 1 ).

Thanks transpower,

I actually put that in, but obviously forgot to remove the "Do not replace existing value in field"

Its all sorted now