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!
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.