Lookup problem

[walent]

Hello, i want to put multiple values in a lookup but they should be ordered I, II, III etc... When i put normal multiple lookup it just sorts them numerically like 1,4,56 but they should be sorted in the order i choose them(e.g I:54 II:23 etc), and displayed like that in the other table... Is this possible with lookup? I tried without but it didn't link properly
edit: Now i've tried multiple lookup but it doesn't show the plus sign in the other table

I would attach pictures but i can't yet

 

[arnelgp]

create a calculated column in your query and sort on that:

Expr1: iif([yourfield] = 54, "a", iif([yourfield] = 23, "b", "c"))

then sort on it:

ORDER BY iif([yourfield] = 54, "a", iif([yourfield] = 23, "b", "c"))

 

[James Deckert]

I made a youtube video for combobox lookups. If you need more help than what arnelgp has, here is the link to show you how to edit the query behind the combobox.
https://www.youtube.com/watch?v=nJXqMJC60oY