lookup lists in alphabetic order

C

cal

Im using lookup lists and the key is an id and the data is then the
second field, I would like these to be in alphabetic order of the data
is this easy? if so how?
 
N

Nick 'The database Guy'

Hi Cal,

All that you need to do it use the 'Order By' clause in your query.

Good luck,
 
Top