>>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.
>
>Erik - what about the case where a line item may have additional line item information in a one-to-one if it is a line item of a certain type?
>
>Example - I sell widgets, things, and doomahickeys - all separate inventory codes for my line items. doomahickey line items have extra information that the other two don't need. Only a small portion of my business is doomahickeys so it is bad-magic (not to mention denormalized) to just add extra fields and null them for other types. I need a one-to-one in a cursor and both updateable.
>
>Stuff like this happens all the time. Surprised you haven't seen it.
>
>thanks,
I have seen it, and this is not a parent-child relationship. It's a one-to-one (brother?). For this purpose, views updating multiple tables work just fine.
Erik Moore
Clientelligence