SQL - How to make a foreign key?

Hi, I'm trying to do an exercise and have just been introduced to the very basics of SQL. I've made 3 different tables and now I want to add relations between them.<br /><br />My question is how to make a foreign key? I have a Table "Person" and a table "Phone number". In Table "Person" my primary key is ID and in Table "Phone" my primary key is Phone number. I want key to also be a foreign key that points on ID in Table "Person".<br /><br />In order to do so I added ID as a column in table "Phone number" as well, right clicked on it and chose relationships. Then I choose Person as the "primary key table" and refered to ID as the primary key and on the right side of the screen I picked ID as the foreign key in "Phone" table.<br /><br />So no I have a ID in Phone table that is a foreign key to an ID in Person table... that's not what I want :S Any suggestions?

SQL - How to make a foreign key?

Hi, I'm trying to do an exercise and have just been introduced to the very basics of SQL. I've made 3 different tables and now I want to add relations between them.My question is how to make a foreign key? I have a Table "Person" and a table "Phone number". In Table "Person" my primary key is ID and…

Read more »