Precisely. If you aren't familiar with sql, just use the wizard. It will prompt you for sort order. If you edit your form to use the query rather than the basic table, it will be sorted as specified in the query.
John 2009/9/18 Bob Williams <[email protected]> > Hi John, > > Many thanks for speedy response. At the moment, my data entry form is based > on > the (single) table. To get it to automatically display records in sorted > order, I should create a query and base the form on that? > > Bob > > On Friday 18 September 2009 19:14:00 jomali wrote: > > Hi, Bob, > > > > Generally, you can have as many as you need. > > > > No, you don't have to delete your ID index. In fact, you have to have a > > primary index in order to enter any data at all. > > > > All additional indexes (indices?) do is to make ordering faster when you > > order on the index parameters. For a name and address database, with only > a > > few records (less than thousands) you are unlikely to experience any > > performance improvements by creating additional indexes. > > > > Unless you are processing many records at a time many times a day, don't > > bother making additional indexes. Just use ORDER BY clauses in your sql > > statements and be done with it. > > > > John > > > > On Fri, Sep 18, 2009 at 1:59 PM, Bob Williams > > > > <[email protected]>wrote: > > > Hi, > > > > > > How many indexes can a database have? I have created a simple, > flatfile, > > > name > > > and address type database. Each entry has an auto-incremented ID > number, > > > which > > > was set as the primary index in the design stage. Now that I've got > some > > > records in there, I'd like to index it on Lastname then Firstname in > A-Z > > > ascending order. Do I have to delete the ID index, which is called > > > SYS_IDX_46, > > > first? Will this activate my new 'Names' index automagically? > > > > > > Thanks, > > > > > > Bob > > > -- > > > Registered Linux User #463880 FSFE Member #1300 > > > GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E > > > openSUSE 11.1, Kernel 2.6.27.25-0.1-default, KDE 4.3 > > > Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [email protected] > > > For additional commands, e-mail: [email protected] > > > > -- > Registered Linux User #463880 FSFE Member #1300 > GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E > openSUSE 11.1, Kernel 2.6.27.25-0.1-default, KDE 4.3 > Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
