>Hi,
> I have a table which will be search using 4 fields together. I would like to ask, should I create complex index using this 4 fields or create 4 different indexes?
>
>Thank you
You can create multiple field keys. In the INDEX ON / TO statement , convert the types to character, dates to DTOS. A nice feature of VFP is SET EXACT OFF, where partial keys maybe looked up.