|
Generating a Primary Key for a Table
Hello,
If I have 2 tables, one for people - say their names, ages, etc. and a second for their addresses (this is because 1 person can have more than 1 address), when someone inputs a new entry for the "person" table, I need to generate a new Primary Key for that table (which will go sequentially beneath whatever's there), and will also go into the "Addresses" table (which can be the same as another key, in case that person already has another address in the table) - how do I get this no.? And then actually do the INSERTing?
Thanks.
|
