>Cetin,
>
>Are you sure that I have an indirect relation? I would have thought I have direct relations between CAPACITY and the other tables mentioned.
>
>I did try and setup the STATE table and setting a relation to it - and the results I got were not good.
>
>Jeff
Jeff,
Maybe it's my terminology :) I meant what you say, relations between "capacity" and others are dominant. Normally a join sequence goes like this :
...from t1 ;
join t2 ;
on t1.fld = t2.fld ;
join t3 ;
on t2.fld = t3.fld ;
...
As if t3 is child of t2 and t2 is child of t1. Setting correct join is sometimes tricky (and yours was too :) and I suggest doing it one by one. That's first connect 2 tables, if OK add 3rd and so on.
Cetin