Many thanks, that's working nicely, now. Bob
On Friday 18 September 2009 20:21:24 jomali wrote: > 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] > -- 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]
