It seems to me that the table is not properly normalized. If the 574 fields have the same kind of information, then you should have 574 separate
records in a separate table. For example, for the present case, with this sort of normalization a single LOCATE FOR would do the job.
>I have 5 tables with a total of 574 fields containing laboratory analysis information on unique items. Each record in a table relates to another record in the other four tables. I split them up because of the limit on the maximum no. of field per record in a table.
>
>The user needs the capability of searching and/ or filtering on any or all of the 574 fields in all tables. Is there something available (sample code in VFP), etc. ? If not what would be the best way to accomplish this?
>
>Thanks to all!
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)