>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.
If it's not broken, fix it until it is.
My Blog