In correct Query Results

B

bmorganh

I have two tables that have been joined with a one to many relationship.
When I run the query all the fields in the primary table show up, but only
one record from the other table shows up and it is incorrectly associated.
Help.
 
J

John Vinson

I have two tables that have been joined with a one to many relationship.
When I run the query all the fields in the primary table show up, but only
one record from the other table shows up and it is incorrectly associated.
Help.
Click to expand...

Please post the SQL of your query, and some indication of how the
tables are related (on which fields), and what you mean by
"incorrectly associated".

You can see your database; we cannot. All I can guess is that the
query is constructed incorrectly; since you did not post it, I cannot
even hazard a guess at *how* it is incorrect.

John W. Vinson[MVP]
 
Top