Pedigree query too complex

[HLarkin]

I am want to build a 4 or 5 generation pedigee with access. I used the
www.allenbrowne.com method (used dog's instead of horses)

I am getting a Query Too Complex message box. If I use 3 generations it's
ok but is there a way I can build 5 or more pedigree generation I get the
message.

Any ideas?

Thanks

 

[Michel Walsh]

You may have a problem of matching parenthesis.



You cannot have more than 32 tables, neither more than 50 levels of nesting
(Access 2003).


Vanderghast, Access MVP

 

[HLarkin]

Do I need to create another query based on the origonal 3 generation query to
create a 4 or 5 generation pedigree?

My ultimate goal is to create a report that shows 5 generations for any dog
selected?

Thanks for your help

 

[Michel Walsh]

Not necessary, but try from the graphical interface, if possible. If not,
try the following pattern, for the FROM clause:



FROM (((table1 AS a LEFT JOIN table1 AS b
ON a.child = b.parent)
LEFT JOIN table1 AS c
ON b.child = c.parent)
LEFT JOIN table1 AS d
ON c.child = d.parent)
LEFT JOIN table1 AS e
ON d.child = e.parent




where the use of parenthesis can be very important, with Jet.


Hoping it may help,
Vanderghast, Access MVP