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