Forum Discussion

kfschaefer's avatar
kfschaefer
Helper IV
10 years ago

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

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!  
Sean's avatar
Sean
Community Champion
10 years ago

kfschaefer You are missing a [GroupName] in the Table that contains the unique values of GroupNames which looks to be GroupDetail table.

 

Meaning in the table on the MANY side you have at least one [GroupName] that does not exist in the table on the ONE side.

 

MainData table                  GroupDetail table

GroupName Column          GroupName Column

GroupName 1                     GroupName 2

GroupName 1                     GroupName 3

GroupName 2

GroupName 3

GroupName 3

 

 

 

  • dejan's avatar
    dejan
    Microsoft Employee
    10 years ago

    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's avatar
      dejan
      Microsoft Employee
      10 years ago

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