Index on the two required fields and seek on those two fields.
>Hi.
>
>I wonder if it's there any way to make searches on two field of the same table at the same time using indexes. I'm using the LOCATE command to search for the two fields wich must be iqual to certain variables. but it's gettin' to slow and the table it's not so big
>big already!!!
>The SEEK command it's eable to search just on one field at the time...or not...
>
>NOTE: I wonder if 'indexes' and 'searches' words are well written although :-)
>
>Thanks