relationships

[Guest]

I have set up a database with Two Tables. I have created one of the tables
and have inported a table from another exsisting database. I have set up a
one-to-many relationship but now I am not sure what to do to make the
information link to the new table.

 

[John Vinson]

I have set up a database with Two Tables. I have created one of the tables
and have inported a table from another exsisting database. I have set up a
one-to-many relationship but now I am not sure what to do to make the
information link to the new table.

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]

 

[Guest]

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