So you're using an IDENTITY column as a surrogate key for your parent rows. Is there a business key available that you could use to find the parent row once created? If so, a simple lookup is what you'll want to do.
John Rowan
====================================================== ====================================================== Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden