3nf child row population problem 1

[schjlatah]

I am new to SQL and have been charged with designing a database in 3NF. I have been having trouble populating rows in the child tables. I can insert into table1 and it will automatically generate the identity column, but how do I populate the child tables with the identity generated by the first table (so as to associate them all together)? Here's a diagram.

Is there a better way to do this, am I way out in left field? Any suggestions?

 

[r937]

look up the SCOPE_IDENTITY function in Books OnLine

r937.com | rudy.ca

 

[SQLDenis]

declare @id int

insert into table1
values('George','Bush')

select @id =SCOPE_IDENTITY -- or @@identity if you don't have triggers on this table

insert into clientPhone
values (@id ,'1-800-President','999-6666666')


insert into clientaddress
values (@id '1600 Penn Ave','Wash'.....)

of course all this in a nice transaction and checking @@ERROR




Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[schjlatah]

Thanks a ton! Now I have a place to start.