[foreign keys auto insert]

Hi 

 

I need some help with the idea of foreign keys please and how they work when inserting data.

 

I have two tables

 

CLIENTS

client_id   PK AUTOINCREMENT

client_name

address_id

 

ADDRESS

address_id  PK AUTOINCREMENT

building_name

street_name

town

 

I want to relate the two via the address_id which I  think I have to make a foreign key in the clients table but am unsure of how to do this. I believe that this will also mean I cannot add a client without a related address. Is this correct? how do I make the address_id in the clients table a foreign key? I am using phpmyadmin via cpanel on my hosting account, do i need to declare it like a primary key?

 

Also when I add a new client with address at the same time via an insert statement how would i get the new address_id to insert into the clients table or would this happen automatically?

 

Thanks