Look-up Tables

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

Can anyone tell me why, I created a field w/i a table that
gets it's data from a look-up table. The look-up table,
has only 2 columns; one with a number and the 2nd column
is a description of what the number represents. In the
look-up table I put the number column in numeric order; 1
to 15. But when this field is brought up in a form, it is
no longer in order (ex: 1, 5, 7, 10, 2, 4, 15 etc). Can
anyone tell me why this happens? Is there anyway to
correct it?

Aurora
 
Did you make the numeric field the primary key?
Access normally shows them in key order.

If that does not solve the problem, create a query that sorts them as
desired (using the Sorting row in query grid), and use that query as the
RowSource for the combo.
 
Aurora

Access stores data in "buckets" (tables), not necessarily organized the same
way you entered it. If you want data displayed in a form to be organized
(i.e., sorted), use a query to retrieve the records and include your sort
criteria in the query.

By the way, I hope you have not used the "lookup" data type in your table --
a review of this newsgroup will reveal a STRONG consensus against using it.
While well-intentioned, what it does is "hide" the underlying key value
actually stored in the table field. This causes problems when querying,
using a form, a report, etc.
 
Back
Top