I have a problem. I have a table with value (text) and value (order) Like that :

text - order
aaa – 02
bbb – 04
rrr –01
ggg –03

Now, it matter to me to have that order sort, because it is imported in another table as checkbox (lookup). So in the table #2 there is some field, and one field should look like

(multiple value check box)
[ ] - rrr
[ ] - aaa
[ ] - ggg
[ ] - bbb

I have SORT the first table value based on the order. THE PROBLEM, and the question are:

The already enter product in table #2 don’t see the list as sort. How to force to sort that list on every product (new and old). even NEW product dont have that list sorter because i guest the sorter only append in the list VIEW. So I do i FORCE the lookup list value to be sorted (NOT ALPHABETICLY)

Thanks in advance

Marc-Andre Menard, IT