November 3rd, 2012, 08:44 AM
How to Make an Entry in a Table and Make in another with same Primary
Well i am currently making a system using ASP.net C# and SQL Server
What i want to achieve is when i create an entry in a Table. Lets say "Customers" with primary key "customerID".
When i create entries in the table and i have a Column with Identity and i successfully entered every data needed.
I want to create an entry in another table with the same value as my primary key.
So in the first table
Name: Mr. Random
it will create an entry in another table like this and the other data are empty.
i want to do this because i separated some data on tables and i want them to have the same key or ID to search or edit them easily.
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.