While we call this a Performer Archive because we developed it for that very purpose, it could be used anywhere where one set of information needs to cross reference another.
We created tho relational web app to keep a repository of all past performers of the Mietta Song Competition. Performers can be searched for along with their accompanist, by name or keyword.
The same web app is used to display and connect the vocalist and accompanist in the competition archive page. In the image below a performers profile (left side) is connected to an accompanist profile (right side) through the app with the details displayed in the respective profiles.