Table reference changed after design master conversion

[sbleland]

Hello,

I have a field (text box) in a table (attendees) that references another
field in a separate table (venue). After converting the database to a design
master, the venue values displayed in the text box are out of order. I tried
sorting the venue table, but the sort is not applied to the text box in the
attendees table. How do I get them to sort properly again?

Thanks!

 

[John W. Vinson]

Hello,

I have a field (text box) in a table (attendees) that references another
field in a separate table (venue). After converting the database to a design
master, the venue values displayed in the text box are out of order. I tried
sorting the venue table, but the sort is not applied to the text box in the
attendees table. How do I get them to sort properly again?

Thanks!

Tables HAVE NO ORDER.

A table should be viewed as an unsorted "heap" of records. This is especially
true if you Replicate the database - Autonumber ID's become random, and a
record with ID 122842524 might be followed by -538227625.

If you want the venues to appear in some specific order you must - no option!!
- use a Query sorting the records by some field in the table. You cannot rely
on the order of records in the table, on the sequential order records were
entered, or anything else other than the actual contents of the table.

 

[David W. Fenton]

I have a field (text box) in a table (attendees) that references
another field in a separate table (venue). After converting the
database to a design master, the venue values displayed in the
text box are out of order. I tried sorting the venue table, but
the sort is not applied to the text box in the attendees table.
How do I get them to sort properly again?

Is it possible you have defined a dropdown lookup at the table level
and used a SQL statement that returns all the fields? If so, this
will cause your dropdown to display the replication fields.

First off, one should never use table-level dropdown lookups (and I
don't know that you are).

Secondly, you should never assume any view of data is going to be in
any particular order if you haven't specifically set the sort order.
If you want the list in a particular order, then set that order
explicitly.