I think we'll need to know more about your fields and the relationship involved.
Are they number or text fields when you check the type in Manage | Database | Fields?
If so, any chance you have entered any leading zeroes, blanks, returns, decimal points or other characters besides the numerical digits in the field of one table and not the other?
Thank you. A case of user error! Some of the names in the match field did not exactly match.