Hey all, I have a table with a primary key in it. I use stored procedures to insert new records. What I want to know is how do I make it so a column (foreign key) in another table adds the same number as the primary key in the original table when a new record is inserted? Thanks.
Using T-SQL
Slade.