I would suggest having a data dictionary of sorts - a list of the field names that you can filter or search on. Then create a query builder that would allow the user to create a select of 1) the fields to display, and 2) the criteria to limit the display.
I had this in an application at an old company I worked at - looked similar to the filter functionality in the view creator in vfp.
>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!
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown