cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Create relationship between two tables, one column is distinct the other duplicates - HELP!

I need to create a relationship between two tables.  One of my tables represents Inventory (uniques values), the others what is Sold, which contains duplicates.

 

The columns I am trying to create a relationship between is Item ID from each of the tables.  But I keep getting this message.

 

Relationship.PNG

 

This will allow me to show the complete Inventory, but also the "Part IDs" that are sold for each item.

 

 

Sample Data:

 

https://www.dropbox.com/s/gbzdwo6qxxt026x/Sample%20Data.xlsx?dl=0

 

 

2 REPLIES 2
Highlighted
Post Prodigy
Post Prodigy

Create relationship between two tables, one table has duplicates - HELP!

I need to create a relationship between two tables.  One of my tables represents Inventory (uniques values), the others what is Sold, which contains duplicates.

 

The columns I am trying to create a relationship between is Item ID from each of the tables.  But I keep getting this message.

 

Relationship.PNG

 

This will allow me to show the complete Inventory, but also the "Part IDs" that are sold for each item.

 

 

Sample Data:

 

https://www.dropbox.com/s/gbzdwo6qxxt026x/Sample%20Data.xlsx?dl=0

 

 

Highlighted
Resolver III
Resolver III

Re: Create relationship between two tables, one column is distinct the other duplicates - HELP!

I was wondering that might be a Cache issue in your Desktop file. Try to clear that and try to make a join again... If you have unique values in one of the table then the error shouldn't show up.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors