INSERT Auto Incremented PK from Table A into FK of Table B

Jun 14 2013 5:38 AM

Sir, Is there any option to make PK auto increment from tbl_A to the FK in tbl_B?

in case of tbl_Division,

divisionId in PK(IDENTITY)

divisionName

classId(FK,IDENTITY in tbl_Class)

if I enter divisionName, divisionId will be generate 1 , but My doubt is would the classId also increament same as tbl_Class date to tbl_Division?

Answers (4)

Primary and Foreign Key in SQL

Stored Procedure