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