Hi Leon,
Obviously some data in the database is going to translate, and some is not.
Names, numbers etc are all "language neutral" - whereas things like Gender can be translated.
the key is to set the DISPLAY field for the browse column. (there on the Field tab).
In your case to
p_web.translate(Sma:Gender)
and then obviously add to the WebHandler as well.
As a complete aside, instead of endless IF statements, you may want to use a CASE statement instead.
cheers
Bruce