>Mike,
>
>I have a routine that grabs all fields from all related tables and even from subqueries in the main query. I only remove the ones the customer specifically wants removed. The code excludes primary and foreign keys.
>
>1. How do all those fields fit in the top part of your form?
>2. Do you allow mutiple seach criteria? How did you do it?
>3. I guess you have a table for your metadata to do this?
>
>Thanks!
>Dennis

It's a grid - one row per condition. A drop down provides the fields with English names from metadata.

Also this form class acts as a picklist, a child form, allowing add on the fly, edit on the fly, delete on the fly and find on the fly.