I personaly, use an approch similar to that because I like to be in control of PK generation.
>Great! thank you - I'm reading the article now.
>
>>>Perhaps this is not the best place to post a SQL Server question, but here goes anyway...
>>>
>>>In VFP, I commonly insert parent and child rows into tables by first generating a primary key value for the parent table and then using that as the foreign key value for the child rows. This way, of course, the child rows are properly related to the parent.
>>
>>An article at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxtk00/html/ft00l1.asp shows how you can do the same on Sql Server.
>>
--sb--