Hi
This is trivial stuff but I can't find an answer in all your resources.
I have a database field containing an integer code e.g. Priority with 0 for High, 1 for Medium and 2 for Low.
The codes mean nothing to the user so I need to translate the code in this column into text. Also, when sorting the column I'd like it to use the underlying code and not the text so the ordered data appears as High-Medium-Low not text sorting which would give High-Low-Medium.
If you can provide some tips on searching your resources for this easy stuff that would be appreciated! A beginners guide maybe
Thanks
RoyS