three tables with identity seed

[onressy]

Hi, I wondering in sql2005 how i can configure two tables to take on the primary key/non duplicating value from another table. I have three table set up like this,
Table1:
appID - primary key/incrementing/non duplicate
fName

Table2:
appID
lName

Table3:
appID
gradYear

When an insert is done on table 1, i would like the primary key value to be created in table 2 and table 3.

Current the table have no data. How can i create this type of relationship? THanks

 

[NoCoolHandle]

scope_identity()

will return the last identity value added