Look-up Tables

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
 
A

Allen Browne

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.
 
J

Jeff Boyce

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top