Cannot create relationship with 1 to many

[rileybloke]

Hi,

I have 2 tables...
1 contains product information, and the product code is a unique key, and the 2nd table contains sales data.

When I try to establish a relationship between the product code in table1 and table2 I get the error..

"The relationship cannot be created because each colum contains duplicate values, select at least 1 column that contains unique values"

But my prodyct code in table 1 is unique.

I dumped into excel and a pivot to check for duplicate and there aren't any.
Totally stumped.

Any advice or help would be great thanks.

 

[prez02]

I think I once had empty rows in a table uploaded via Excel that prevented creating a relationship?