Thank you for your post.
It will be a bit difficult without being able to see the file, but my first instinct would be to review the Relationship between the two tables. Copy down the criteria that makes up the relationship, and make sure there are more than one record that satisfies the relationship. It may be due to just a slight typo.
If you are still having difficulty, then please provide some examples so I can test it out here.