Forum Discussion

rjunai200's avatar
rjunai200
Helper I
10 years ago

creating relationships

      trying to create relationship between two tables. can anyone tell me why its giving me this error and what i need to do to connect it? i am trying to link the corp ae table to corp ae table ...
Need Help
ruecj5's avatar
ruecj5
Advocate I
10 years ago

To establish a relationship between two tables, the columns have to have a 1:1 or 1:Many relationship with the data they contain.

 

Based on the screen shot, the columns you would like to create a relationship between do not have a 1:1 or 1:Many relatioship.  I can't tell for sure with just 3 rows of data, but it looks like you have a Many:Many (each unique response appears many times in each column) type relationship, which does not work.

 

If you are looking to pull Sales Office/Sales Market from 'Sheet 1' in to 'Category Report' and the list of unique names in column [Corp AE] is the same for both tables, you would need to de-duplicate 'Sheet 1' based on column [Corp AE] so that each unique name in the column only appears one time.  If that is something you are able to do, you can establish a 1:Many relationship between the two tables.

 

- Chris