I don't know. I have a form that is based on one table that has a primary key that is a text field. Without anything being declared the form is sorting by the primary key on the table. If I add a field to the form from a second table, the records now seem to be sorted by the primary key of...