Database replication

[Richard Crum]

I replicated a database and then I sorted a table in the design master in
ascending order. Now when I open the drop down box the data is not in
ascending order but it is in the corresponding table. What is going on and
how do I correct it?

 

[Alex Dybenko]

make a query on mentioned table, make sort on required field there and use
it as rowsource for drop down box

 

[John Vinson]

I replicated a database and then I sorted a table in the design master in
ascending order. Now when I open the drop down box the data is not in
ascending order but it is in the corresponding table. What is going on and
how do I correct it?

Tables HAVE NO ORDER. Sorting a table datasheet affects the *display*
but not what's stored.

If you want a combo box to be sorted in any particular order, create a
Query based on the table sorted by some table field. If it's an
Autonumber field that defines the order, you're out of luck -
autonumbers become random when you replicate. If you're assuming that
autonumbers are assigned in sequential order as records are added,
that assumption is incorrect.

John W. Vinson[MVP]