Forum Discussion

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper 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!  
dejan's avatar
dejan
Icon for Microsoft Employee rankMicrosoft 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
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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