>I have other joins involved for program flexibility. I am using a custom filter, which is where the contents of the macro are set. The filter options at a max give them the ability to query using fields in the other tables.
Just build whole select on the fly and use one macro :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.