*snip*
>I guess that's possible, but I have never used a parent child view for that. My more common scenario goes that I want to show a child record alongside information from its parent(s). I can use that same table to add a new child to a given parent, but I don't want to add a new parent at the same time.
>
>I think the business need for adding a parent and a child at the same time to the same cursor is probably much rarer. I've never had a need to do it.
I guess the most common occurrence is the 1 - 1 relationship between parent and child. While they are rare, they do exist. The much more common 1 - many relationship could not use this type of view.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao