Multiple Fields lookup with index problem


After my index problems with NDX files, it was suggested to use MDX files.
Ok after installing Vis dBase, I created some test MDX files.

BUT, if I want to search on a combination of a numberic and a string value it
doesn't use any of the indexes.

What is going on????

I wanted to change to Delphi, but in the last week I only had database

Tell me, what is the best and fastest database to use.
No options that cost money, because I'm building a program I want to give away
free. I have a lightning fast program now in Clipper, and want to switch to

Happy Hacking The Graphical Gnome

| Rob den Braasem    | Voice :-31-79-3531520 |
|                    | Fax   :-31-79-3513561 |
|                    | Mail  :  |
|                    |-----------------------+---------------------+
| KTI bv             | "I die when it's time for me to die.        |
| P.O. Box 86        | So let me live  my life the way I want to." |
| 2700 AB Zoetermeer |                                             |
| The Netherlands    |   Jimi Hendrix                              |