Can't Create Relationships - missing intermediate data to connect the two columns

Question

I am attempting to create a relationship between the MainData Table and GroupDetail Table via the GroupNumber & Group Name. However I am getting the following issue:

Why?

Thanks!

anonymous · Answer

kfschaefer&nbsp;Maybe I'm not understanding something... The relationship would be on Group ID in both tables... Is this the case, and your description makes it sound like you are trying to create a relationship from name to ID...

sean · Answer

kfschaefer&nbsp;You are missing a [GroupName] in the Table that contains the unique values of GroupNames which looks to be GroupDetail table.&nbsp;Meaning in the table on the MANY side you have at least one [GroupName] that&nbsp;does not exist in the table on the ONE side.&nbsp;MainData&nbsp;table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GroupDetail tableGroupName Column&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GroupName ColumnGroupName&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GroupName 2GroupName&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GroupName 3GroupName 2GroupName 3GroupName 3&nbsp;&nbsp;&nbsp;

dejan · Answer

Try to copy (duplicate) GroupDetail table, then remove all columns from this table except GroupName. Then remove duplicates. This new table that will contain all unique values for GroupName can be used as your intermediate table to connect GroupDetail and MainData tables. Hope this helps.

dejan · Answer

In this case, maybe it will be better to use MainTable since it contains all GroupNames....

mork · Answer

Usually this happens because one of your columns doesnt have all the data that the other has. Another requirement of the relationship function though is to not have any blanks in either of the two columns that you are trying to relate and also only one of the two columns is allowed to have the same value multiple times. One of the two columns always has to have each distinct value once.

Forum Discussion

Can't Create Relationships - missing intermediate data to connect the two columns

6 Replies

Related content

Relationship

Relationships

Multiple Intermediate step

Relationship Issue

Relationship with direct and intermediate tables