|Subject||Re: [ib-support] Showing a different value|
> I have a field which contains a value, say 0,1,2,3,4,5Create a extra table with the lookup's.
> Now if the value is 0, I want to display the letter B, if the value is 1,
> then I want to display the letter O, if it's 2 I want to display E, if it's
> 3 oh you get the idea.
> I want to display this within a select so that the number is
> retrieved, and the letter is displayed. Anyone know a simple way
> to do this?
NUM = LET
and then use an inline select
( SELECT LET FROM LOOKUP WHERE NUM = MAIN.NUM ) AS LETTER
I use this a lot so that the customer can change the names
of queues or displays. They just edit the LET entry in the
L.S.Caine Electronic Services