Thanks Mike! Explained it better than I could have (g)...
Evan
>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?
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?