filling list box from table

[dreamdelerium]

hi everyone, i got a question

in my forms i have a control that has two columns, one with text the other with a value (ie value1;0;value2;1...etc). when it gets saved to a table, i only save the value not the text (0,1...). now, when i want to load the data from this table to the forms listbox i dont want to display the number but rather the text. how can i accomplish this?



thanks for your help

jason

[Hack]

Where is the text saved?

[dreamdelerium]

i have everything stored in a look up table that stores all possible numerical values and their coresponding text

[Siddharth Rout]

Copy the relevant data from the table to an array and then assign the array to the listbox's list property...