Index and sorting question, help! :)
Quote:
> Hi,
> I am working on an application that utilizes (at least) two tables. One
> has 6,300 records, the other 60,000. I want to associate records from
> table to the other. I know I can do this with a link table. The problem
> is that I mist be able to search quickly through this third tabe since it
> will be the largest by far. I was going to sort the entries by the number
> from the smaller table, but somehow I wonder if an idex would be better.
> The hitch is that there is nothing in my manuals or the on-line help that
> explains how to use indexes.
> Would someone point me in the right direction here? I don't expect you to
> explain this all to me, so if you can recommend a book, that would be
> fine.
To use indexes you need to have your recordset as a table object. In
your code assign the index I.E.
data1.index="Indexed Field"
That's all you need to use them.
You can create indexes through code but just cheat an open Access and
define them there (unless you need dynamic indexes).
