filling list box from table

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

Where is the text saved?

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

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