> I want to insert a parent record and a bunch of children (the children > are going into a few tables). How can I get the uniqueid back from the > stored procedure, so that: > > 1) the children can have the right uniqueid form the parent; and > 2) I know what record I just added? > > What I'm thinking of here is something like an invoice number that is a > system defined visible key. you probably use record buffering for the parent and table buffering for the chiled records you can set a predefined (in the SP for example) dummy number for the parent and chield records then use triggers (update) and RI (refrential integrity) builder to make the update in the parent's ID bubble to the chield ones Arnon