how can I sort the number from the smallest to the biggest using SQL? Also, how can I look up data under the same the field or 'column' using dblookupcombobox? My situation. I have 200 items in the table, and each item is grouped under 1 out of 7 types of dish types: SEAFOOD, FRIED RICE, etc... Is that possible to group those 7 types under some sort of dropdown box, then using SQL Command: select * from menu where types = 'dropbox'; thanks

引言: how can I sort the number from the smallest to the biggest using SQL?

• the number from the smallest to the biggest： Select * From TableName Order By FieldName
• the number from the biggest to the smallest： Select * From TableName Order By FieldName Desc

引言: how can I look up data under the same the field or 'column' using dblookupcombobox?

http://delphi.ktop.com.tw/topic.php?TOPIC_ID=28065

May be i am asking the wrong question. because I don't get a clue of what that post is saying. How about design a drop box that contains fixed options. say: Rice Noodle FastFood etc.. .. So the drop box have no related to any table.