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!