"Unsorting" a value list

[JD2775]

I have a value-list field that contains values from another field in a related table.

In the table the records show up as

2

5

4

3

6

8

1

10

7

In the value list, however, it sorts them

1

2

3

4

5

6

7

8

9

10

How can I set the value list to mimic the order they actually are in the table? Seems like it would be such an easy thing to do but I cant figure it out. Im using FMP10 if that matters.

Thanks

[comment]

No, it's not easy. As a rule, value lists using values from a field are sorted in ascending order (you actually see the index - that's why duplicates are removed too).

See here for a limited workaround:

http://fmforums.com/forum/topic/49445-value-list-sort-problem/

[JD2775]

Wow, it's not easy. Thanks for the link, Im gonna give that a shot