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