Indexing

[Andrew Wayne]

In a data base design i have several fields in a table
including "ID"(AutoNumber) "LastName"(Text) and "Envelope
Number"(Number)

The indexes are LastName (ascending)(allow duplicates)
and Emvelope Number(ascending) (No duplicates allowed)

I have a combo box to Lookup the LastName, however the
records are not in alpha order. It seems to conflict by
having the index on Envelope Number. I understand I
could use the combo box and base it on a query, but when
I start the Combo Box Wizard, it does not give me the
choice to base the Combo on a query.
Thanks for any help
..

 

[John Vinson]

I have a combo box to Lookup the LastName, however the
records are not in alpha order. It seems to conflict by
having the index on Envelope Number.

Unlike the case with some other database software, specifying an Index
does NOT sort the data. It merely makes any Query which you create
with a sort clause work faster.

I understand I
could use the combo box and base it on a query, but when
I start the Combo Box Wizard, it does not give me the
choice to base the Combo on a query.

Ummm... yes it does. When you are offered the data source, there are
three radio buttons below the list of tables: Tables, Queries, or
Both.


John W. Vinson[MVP]