database problem

i have 2 database tables and want the primary key from table 1 to appear in table 2. The tables are connected to two web forms, so in other words, the user enters personal details into form1 which is sent to table1..then the user enters company details into form 2 which is sent to table 2, the trouble is, is that at the moment there is no way of telling which personal details relate to which company details...

ok, i think i get the first bit.

Freon22 wrote: Well there are a few ways, one is the example that I show you. INSERT INTO table 1 (field1, field2, field2) VALUES (value1, value2, value3); SELECT Scope_Identity() When you use a insert with a Select Scope_Identity at the end it will return the primary key number for that record. Atleast with sql2005 database if you are using access or someother database you will have to look into what method is used for returning the record number.   Anyway you can then put the id number in a variable and use it when you insert the data into table 2.   Or you can just insert all of the data into both tables at the same time. I setup a few tables so table_1 has these fields user_id, user_name. table_2 has company_id, user_id, company_name   INSERT INTO table_1 (user_name) VALUES ('Jim');  INSERT INTO table_2 (user_id, company_name) VALUES (Scope_Identity(), 'Help Company') Now if I run both of these inserts in the same connection it will put the primary key user_id from the record in table_1 into the foreign key field user_id in table_2

Freon22 wrote: Well there are a few ways, one is the example that I show you. INSERT INTO table 1 (field1, field2, field2) VALUES (value1, value2, value3); SELECT Scope_Identity() When you use a insert with a Select Scope_Identity at the end it will return the primary key number for that record. Atleast with sql2005 database if you are using access or someother database you will have to look into what method is used for returning the record number.   Anyway you can then put the id number in a variable and use it when you insert the data into table 2.   Or you can just insert all of the data into both tables at the same time. I setup a few tables so table_1 has these fields user_id, user_name. table_2 has company_id, user_id, company_name   INSERT INTO table_1 (user_name) VALUES ('Jim');  INSERT INTO table_2 (user_id, company_name) VALUES (Scope_Identity(), 'Help Company') Now if I run both of these inserts in the same connection it will put the primary key user_id from the record in table_1 into the foreign key field user_id in table_2