Replicate Sort Order

[Guest]

I have come across a problem getting my replica to behave the same as my
Design Master and I'm hoping someone on here can give me a way to fix it:

I have created a database containing a form with two drop-down list controls
referencing data in tables seperate from the main control source of the form.
These lists contain names that when sorted by Primary Key (Random), are not
in alphabetical order, so made the row source of the lists a query with the
records sorts ascending by name. This fixed the probelm in my design
master--when you click on the drop down list now, the names it contains are
in alphabetical order. HOWEVER, the replica still sorts them in Key order,
even though the querys did copy over to the replica.

Any idea why something like that would work from the design master but not
the replica? I have tried synchronizing a couple of times now, so it's not
that it's not up to date.

Thanks in advance for the help!

 

[Douglas J. Steele]

Base your list boxes on queries, not tables, and put the appropriate ORDER
BY clause in the query.

You should never make any assumptions about the order of data in tables.