left joins limit?

[Martin]

I have a query with 30 left joins when I put a 31 it gives
me query too complex. Is 30 the limit?

Thanks

 

[John Vinson]

I have a query with 30 left joins when I put a 31 it gives
me query too complex. Is 30 the limit?

The QTC error arises when the entire query exceeds 64KBytes after
compilation. It's probably just coincidence that this is happening
after 30 joins in your case.

I really have to wonder about your table structure! Sounds like a sea
urchin... are you linking 30 (or fifty, or how many?) dependent tables
to 30 (or fifty) separate fields, or what?

 

[martin]

I have a table registrants with many tables linked to it.
For instance there are tables marriage status, referred
by, and so on... This query I wanted for a report that
would print out all of the Info not just the codes that
were used in the registrant table to link to the other
fields.

P.S. dlookup is way too slow to use.