Cross reference multiple tables

[nando88]

I want to relate multiple table together to a single field, and that way I can use data from multiple tables in a single visualization. Can someone please tell me if this is possible and if so, how?
Thanks. The tables |I have contain duplicates.

 

[FDibbins]

What do your tables look like?
What do they contain?
How would they be linked?
What does your expected outcome look like?

 

[nando88]

What do your tables look like?
What do they contain?
How would they be linked?
What does your expected outcome look like?

I want to get all the data I can from all the tables that are linked, the problem is that some tables contain duplicate values and I don't know if this is possible to do with duplicate values, since I always get the error of unique values.