Is there anyway to sort a referenced drop down in the order that I want? (NO ASC NOR DESC)

[Jon_Capria]

Hi,

Starting with the two tables:

• Customer Table
• Order Header Table

In the Order Header form, I have referenced the customer table so I can select which customer is purchasing from me… So far I have found out how to sort by name asc or desc but I was wondering if there is any way to sort the dropdown in the order that I want.

The whole purpose is convenience, I have a customer who purchases way more often than the rest but his name starts with an M so I always have to scroll down or type his name in order to select him and it would be so much easier if I had him on the top and the rest asc order.

If there is any way to do that I would appreciate it your thoughts and ideas.

Thanks.