>Hi Erik,
>
>>Seriously, no personal offense, but I have never gotton anywhere trying to implement a cyclical relationship in a single query. If it doesn't bomb, it usually narrows the result set to nothing. I am really curious as to how your suggestion worked.
>
>The suggestion is not cyclic (I assuming I know what that means) it check the foreign key from detail2 to detail1, then from detai1 to master. Cyclic would mean another one from detail2 to master, right?
Mike, you're right. I read the post too fast- I saw three joins on three tables, and my eyes told me they were being joined in a circle. Thanks for keeping me on my toes.
Erik Moore
Clientelligence