newbie question, link tables

Hi all, Can I link two fields in two tables, in the way that if I add a new value into a table in the other table the value is added automatically, or Do I need to add the values one time for every table? Thanks for helping me. Pedro -- MySQL General Mailing List For list archives: http://li

new to databases, multiple relations

Hi all, I have to create a database where the elements of a table are related to elements on the same table. What is the best (optimised) way to do that? I came with the model: CREATE TABLE locations( location_id int(11) auto_increment, location_name varchar(50) NOT NULL default '',