>>>This is what I have been doing (since I posted my message). The issue (could be but hopefully not) is that the query string will be longer than is allowed. My query string (to include both sets) will have the WHERE FIELD IN (.) and the IN expression could be long. Theoretically. Thank you.
>>>
>>If you set the SelectCMD in code, the length of the expression does not matter. Although it may be better to not hardcode long lists and have them in the separate table.
>
>I do set the value of SelectCMD in code. So you are saying that if the length of this expression is even 1000 characters it will work? If so, this is very good. Thank you.
>
>P.S. Keep in mind that even though I set the value in code, it is data driven so it is not per se "hard-coded"
Yes, I think it should work just fine.
If it's not broken, fix it until it is.
My Blog