I am trying to link 2 fields together from 2 difference sources. The fields have been named identically, both are strings and when i look at the data from each source on separate sheets i can see the same data but there is no icon to link them together.
I cant share the workbook but have taken screen shots of the issue.
Hi - i think i figured it out.
Data->Edit Relationships and then create a custom relationship