> > haven't tried w/ automatic adding of child records, but wouldn't you add > > the parent first (getting the uniqueid) and then store the uniqueid (or > > parent record #) to use when you add the children? > > Ok, so you do an INSERT INTO, > > then what's the parent key? if the parent key is set before the chield records are created you - I don't see the problem if the key would only be set in the end (e.g. you create an invoice and only after it is ready you set the invoice number) - then take a look at my other reply Arnon