Forum Discussion
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!
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.
In this case, maybe it will be better to use MainTable since it contains all GroupNames....