It won't write the data into the other table. What you are looking for is
information on "Primary Keys" and "Foreign Keys". The code you mentioned
would be the Primary Key of the table you have created. The new table should
also have its own Primary Key, but it should also have a field for the
Foreign Key. This field would be linked in the relationships window to the
Primary Key of your current table. You could then use a query, add both
tables to the query, and the query could return fields from both tables
using the linked fields to keep the tables "aligned" with each other.
Please look at the Northwind sample database that comes with Access and you
will see this in action.
--
Wayne Morgan
MS Access MVP
"pau" <pa**********@hotmail.com> wrote in message
news:dv**********@news.ya.com...
Hello, i need your help again. Now im building a table with all the hotels
in my town. I put two columns. One with the name and one with a code in
autonumber. I create a relation with other table and i want to know if is
posible only writing the code the access writes the name and more
information in this other table. Thank you.