Relationships Issue

[emma313823]

Hi All

I have an issue which I can't seem to figure out what is causing it.

I have pulled in two tables of customer related data of which a common relationship is the part number.  I pulled out a list of part numbers and created a unique table (all duplicates removed), so I can then create a one to many relationships from the unique part number list to the customer list. 

When I try to create a relationship from the unique part number talbe to the customer detail table, it tells me I can't create a relationship because I must have unique values and I'm 100% positive my part number table is unique values.  Both tables show the part numbers are set to text also.  Any idea how to fix this?