Database replication

  • Thread starter Thread starter Richard Crum
  • Start date Start date
R

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?
 
make a query on mentioned table, make sort on required field there and use
it as rowsource for drop down box
 
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?
Click to expand...

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]
 
Back
Top