Hey guys, im new to this forum but I had a question about mysql.

I am pretty new to mysql and I want to be able to have 2 tables where one of the fields from the one table is always equal to that field in the other table.

Reason bieng, I dont want to add about 15 columns to the one table that already has 8, i want a whole new table for that info and i want to link them using the id's of the person. So when you click on a link of the person and it sends the id to the webbrowser i can search the id from the other table instead of the one it just loaded.

Ok so basicly I want 2 tables to somehow share one column.

Thanks

Bryan