Yes, you do need to make sure the grandfather is selected. A relation only has meaning from the parent of it.

Try to set the skip to child1, child2 (you can do it one line I seem to remember) from the Grandfather.

Gee, I guess I have really moved away from Set relations to p-views. I used to know relations "cold." ;)

>
>select grandfather
>set relation to supermkt into parent
>
>select parent
>set relation to market_ind into child1
>set relation to supermkt into child2 additive
>set skip to child1, child2
>select grandfather
>
>(This is exactly the code I'm using; I've only changed table names to make it easier to read.)
>
>There is a one-to-one relationship between grandfather and parent, and one-two may relationships between the parent and each of the children. I tried setting the OneToMany property to False and True for all tables, with and without the code in the init event.
>
>I noticed that if I did not select grandfather at the end of the Init code, the report wouldn't work properly at all. I'm assuming this is related to the InitialSelectedAlias Property of the Data Environment.
>
>Thanks for all your help.