SQL and windows forms- Please help.

Question

I have two tables.

table 1 fields are cricID,CricName

table2 Fields are CricID,phonetype

table 1 cricID is primary key, table 2 cricID is foreign key to table1

My question is i have to insert data in both the tables. I could insert data in table 1, but i donno how to insert in table 2 because of the foreign key value. I am new to SQL . how to get foreign key value from table 1 when i insert in table 2

Star · Answer

Load data in insert into table1(cricIDCricName) values (1'sairam'); commit; insert into table2(CricIDphonetype) values (1'land line'); insert into table2(CricIDphonetype) values (2'mobile');

sairam · Answer

thts just an example .... infact i have some other fields in those tables. linked by a common field. can u help me reg this

Mahesh Chand · Answer

You don't need two tables for three columns only. You are basically adding redundant data in second table. This is a bad database design. If you want to add data to second table you want to make sure first table has data and then only you can add row to the second table.