Jason,
That worked great, it seems I was trying to do too much... Hoping to do single queries using both full recordsets.. But it doesn't seem to be to bad performance wise with the correct indexes.

Now on to the remaining issues.. How can I import the records from one recordset to another? I have tried and the only solution I have found so far would be using the getrecords method to move the records into an array and then append the array using .addrecord Fieldlist, Values.

Is there a more efficient way that I am overlooking?

Thanks in advance,
-J