Hello All you Brainy Filemaker people.

Can anyone please advise me how to do the following:

I am trying to ask filemaker to enter a new text string depending upon the value entered in a previous field, I have found the following works for a single value, but how do I tell it to enter something else if the Serial Number was 60 ??

Substitute ( Serial Number; 50 ; "handmade" )

Any help is most appreciated... thanks for Looking.

You haven't to use the Substitute ( ) function...

Try with Case ( ) or Choose ( )

Case(

Serial Number = 50 ; "handmade" ;

Serial Number = 60 ; "somethingElse" ;

"yourDefaultThing"

)

Daniele,

Grazie così tanto that' s perfetta, lo avete conservato ore..