ODBC indexes thread637-1720718
ODBC indexes thread637-1720718
(OP)
>> AR Invoices and Cash Receipts
Just a followup on an old thread637-1720718: What to do? Crystal Report tables don't have common indexes - slow
I finally discovered a limitation in the ODBC driver being used.
Documentation states.... limit of one left outer join per query.
Once I realized this restriction I was able to get the results I needed.
Now use sub-queries in Access and sub-reports in Crystal when I need multiple open joins.
Very slow but... at least it works.
New to me, I'd never heard of a restriction like this before.
Just a followup on an old thread637-1720718: What to do? Crystal Report tables don't have common indexes - slow
I finally discovered a limitation in the ODBC driver being used.
Documentation states.... limit of one left outer join per query.
Once I realized this restriction I was able to get the results I needed.
Now use sub-queries in Access and sub-reports in Crystal when I need multiple open joins.
Very slow but... at least it works.
New to me, I'd never heard of a restriction like this before.
Bruce O