Help with list box

[#1]

Hi Guy's

I have something im trying to do , hope its possible.

I have a field in my database called Authorization Type which has two results, 1 and 2. I would like to make this more user friendly by making the list box display crack for 1 and NIS for 2 instead of just displaying a 1 or 2.

Is this possible at all ?

Help is very much appreciated.

[sunny_talwar · Accepted solution]

May be this for your listbox expression:

Pick([Authorization Type], 'Crack', 'NIS')

[#3]

yes you can

You can add an IF() function in your load script to look at a value and set the field

if ([Days] > 45,'Over 45'))) as Status - this example is checking the value in the days field and based on the value setting the sttus field.  If you have to values your test would be something along the lines of

If([Authorization Type] = 1, 'Yes','No) as [Auth Type] and use Auth Type for your list or as [Authorization Type]

[#4]

That worked perfectly , thank you so so much

[sunny_talwar]

Awesome