If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Indexing
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 .. |
#2
|
|||
|
|||
On Wed, 16 Mar 2005 18:38:48 -0800, "Andrew Wayne"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
improving performance by indexing query criteria fields | Paul James | General Discussion | 20 | February 16th, 2005 07:55 PM |
improving performance by indexing query criteria fields | Paul James | Running & Setting Up Queries | 20 | February 16th, 2005 07:55 PM |
Indexing | Cindy M -WordMVP- | General Discussion | 0 | January 16th, 2005 09:35 PM |
Seaching through exchange 2000 with Full Text Indexing ON - BUG ? | Neil | Contacts | 0 | July 17th, 2004 06:14 AM |
Indexing | Al Camp | New Users | 2 | May 8th, 2004 01:08 AM |