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.
Amanda Morton
System Analyst
Harrisburg Project