Assigning Foreign Keys
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.
Slade
Practically a Master Poster
633 posts since Mar 2004
Reputation Points: 115
Solved Threads: 7