How to link data from different contacts?

We are a social enterprise and have many different types of "clients." We serve local Mexican artisans (which we refer to as clients), plus, tourists, professors and university students.

We register each tourist's visit with dates as well as which artisans they visit. In the future, I would like to be able to do correlate a tourist and the artisan so as to update the tourist when the artisan has interesting news..

Is there a way I can run such a report between Contacts??

Thank you.