>Hello Nadya (and Al),
>
> I fixed it!! But I am also red in the face. I DID have a local view, clients_townsview, in the final SQL-SELECT. I had missed it earlier. It needed to be requeried before the start of all the SQL-SELECT(s), and in doing that, it now works as it should all the time.
>
> Thank you for your trouble.
>
>Sincerely,
>
>Jerry

I'm really glad, you found the cause. I guess, we would unable to help you here...

Best wishes.