Link 2 data from 2 tables without the same name

[Luca_Luca]

Hello, 

I am trying to link different data from differents database, but the problem is that on one database I got for exemple the client :
"Airbus" and in the other database the client name is "Airbus TEST" but we can also have "Airbus Test Number 2". Is there a way to link everything so when I click on one chart with "Airbus" from the first database, in another chart it show : "Airbus TEST" and "Airbus Test Number 2" from the second database ? 

My idee behind it is to have different level of selection to show specific data to a client. 

Best Regard,

Luca
PS : Sorry if it had already been answered but I didn't manage to find anythings.. 

[miTutorials · Accepted solution]

You will have to create another linking table to achieve this. And then use the first column to fetch all different Airbus.

Regards

Ismail

www.youtube.com/MiTutorials

[Luca_Luca]

Many thanks ! It's working fine 

Regards,
Luca