Hello everyone,
It was great learning stuff today. Let me recap
1) Thanks Dean for pointing out not to store dbname in client var and
instead store in appl var
2) Mischa, your input really got it all started. As per your last email, I
have made some changes and I think t
My whole suggestion
about combining State and Reason_Text in
one custom field, was so that you wouldn't
have to sacrifice the Reason_Text
Without trying to understand
too much of your query...
step 1: run query
SELECT field1, field2,
..., Reason_Text + "|" + State AS ContentsOfCusto