<div>
Thanks for the answer. We need both numeric and alpha. It is just that there are about twice as many numeric and they are used the least. New people are starting to use the database and I was hoping to make it as easy as possible for them. I think I will make it as easy as possible for me and just leave it as is for now.
</div>


Thanks for the answer. We need both numeric and alpha. It is just that there are about twice as many numeric and they are used the least. New people are starting to use the database and I was hoping to make it as easy as possible for them. I think I will make it as easy as possible for me and just leave it as is for now.

<div>
<div class="content wysiwyg-content">
Is it possible to control the way a list of data from another table is displayed in a layout using the drop-down arrow.<br />
Many records were added with a numeric AgencyCode. A change in status results in the AgencyCode becoming a 4 letter code. When using the drop-down arrow all the numbers come first. Is there someway to sort the list so that the alpha codes come first?
</div>
</div>


Is it possible to control the way a list of data from another table is displayed in a layout using the drop-down arrow.
Many records were added with a numeric AgencyCode. A change in status results in the AgencyCode becoming a 4 letter code. When using the drop-down arrow all the numbers come first. Is there someway to sort the list so that the alpha codes come first?

Filemaker Pro 10 display order

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.