Greetings from Bonnie Scotland
I thought it would be a good intellectual exercise to try and use Access to build a database of operatic information.
The original idea was to have a database showing the names of operas along with their composers, synopses and other general information. Ambition then outstripped ability when I thought I would add arias for each of the four voices, together with the original lyrics and English translations. I would then add a further list of tenors, sopranos and so on and link this to actual mp3 files of the arias. I am now swimming in a sea of " one to manys " and " many to manys". I have not even got round to thinking of duets, trios, quartets.....
Perhaps I should stick to fishing and golf.