What do you expect to see?

If you create a Query and add both tables, Access should automatically
join the two tables on the linking field that you have defined. You
can then open this Query (or, better, base a Form or Report on the
query) and see all of the fields from both tables.

If you have multiple matching fields in both tables and you're
expecting the data to automagically fill itself in to both tables,
you're misunderstanding relationships (this is a very common error for
folks getting started with Access, or I wouldn't raise the question!)

                 John W. Vinson[MVP]    

The primary key in one table should match a field in another table and then
you get the one to many relationship.