Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
setting indexes
- Thread starter scottshiv
- Start date
The records are presented naturally in primary key order.
If there is no primary key, the first unique index is used.
If you want any other sequence you can sort the datasheet using the toolbar buttons or use advanced filter/sort from themenu or create a query.
If there is no primary key, the first unique index is used.
If you want any other sequence you can sort the datasheet using the toolbar buttons or use advanced filter/sort from themenu or create a query.
have the database reflect that order
A relational database has NO order.
To retrieve records in a predefined sequence you have to write a query with an explicit ORDER BY clause.
This query may be optimized if the sort fields are properly indexed.
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
A relational database has NO order.
To retrieve records in a predefined sequence you have to write a query with an explicit ORDER BY clause.
This query may be optimized if the sort fields are properly indexed.
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question