Adding Auto-Increment ID in both parent and child table
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
Hie, I tried out samples in MSDN regarding how to enable autoincrement of an ID through Stored Procedure, it works. Now I'm having doubts where I wanted to insert the ID which is auto-incremented in parent table when a new record is added, to be inserted in the child table. I just make an illustration for example, StaffAccount Table (Parent Table)having StaffID as primary key, it is auto-incremented using stored procedures-succesfully completed, now the StaffID is the foreign key in Login Table(Child Table), I want the StaffID to be added automaticallly in child table once a new record has been inserted in parent table. How is this possible? Thanks in advance for helping in reading this. =) best regards amygal