Single Report from Multiple Tables

[Scott_66701 via AccessMonster.com]

I am trying to join my tables together through a relationship. All my tables
have a primary key that is called "RunNumber". I can't get the tables to
join so I can make a single report from all of them. How can I do this.

 

[Arvin Meyer [MVP]]

To relate records, you need a corresponding Foreign Key on the RunNumber
field.

 

[Scott_66701 via AccessMonster.com]

Please give an example.

To relate records, you need a corresponding Foreign Key on the RunNumber
field.

 

[John W. Vinson]

I am trying to join my tables together through a relationship. All my tables
have a primary key that is called "RunNumber". I can't get the tables to
join so I can make a single report from all of them. How can I do this.

What are the structures of your tables? It sounds like you have one to one
relationships, which in practice are quite rare: if the terms "Subclassing" or
"Table based field level security" are unfamiliar you're almost certainly on
the wrong track!

Please explain the nature and content of your three tables. My guess is that
you either need ONE table, or three tables in one-to-many relationships, and
that only one of them should have RunNumber as the primary key.

 

[Arvin Meyer [MVP]]

Sure. There is a sample database named Northwind that should have installed
if you did a complete Office/Access install. You can find it in the Help
menu. Look at the tables and use the Relationships diagram (in the Tools
menu) to see an example. The tables and relationships to look at are the
Products, Orders, and OrderDetails tables. You can also get a good
background at MVP Crystal Long's tutorial website:

http://www.accessmvp.com/Strive4Peace/Index.htm