>>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.

Actually, it didn't work. But in my mad rush, I hadn't looked at the data properly. I ended up haven't to do a two-stage query. Pulled the master and one detail table into a cursor, and then pulled the second detail joining with the SONO+INUMBER.

Thank you for your help.