query gets wrong data from tables

[blee via AccessMonster.com]

Hello and thanks for your help. I'm new to Access and am trying to figure
something out. I posted a similar question last week, but am still getting
the wrong data in my query. Any help much appreciated.

I have two tables, one for Athletes (and demographics) and one for Injuries.
They are related on Athlete ID, an AutoNumber in Athlete table, foreign key
in Injury table.

When I run my query (in order to print a report), something isn't right. For
example, if I use the Athlete ID number from the Injury table and get the
first/last name from Athlete table, it pulls the correct # but relates it to
the wrong athlete name. If I use the Athlete ID and first/last name from the
Athletes table, it gets the wrong ID # and wrong name. Either way, the other
data is correct (ie injury location, date of injury, etc.)

I've made and re-made both tables and am at a loss as to what I'm missing.

Thanks
Brian

 

[Jeff Boyce]

What is the data type of the foreign key in Injury?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[blee via AccessMonster.com]

Long Integer

Thanks
Brian

What is the data type of the foreign key in Injury?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello and thanks for your help. I'm new to Access and am trying to figure
something out. I posted a similar question last week, but am still getting

[quoted text clipped - 21 lines]

Thanks
Brian