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?