correct way of linking columns/tables 1

[cammy]

Hi

I have a series of tables setup, some of which contain columns named the same, such as 'clientid'. The first clientid value is generated by auto_increment in the 'clientaddr' table and when I add a client contact, this value is passed using a query string and inserted using a form field into the 'clientcontacts' table which also has a clientid column.

I am a beginner at this and am unsure if this is the normal/correct way of linking/joining tables.

Any advice would be appreciated.

Cheers

Cammy

 

[feherke]

Hi

Yes, it is correct.

Feherke.

http://rootshell.be/~feherke/

 

[guelphdad]

yes that is the correct way of keeping your content consistant. If you are not aware of using last_insert_id to insert the clientid from the first to the second table you might want to check out this article