So here's my predicament:
I have 3 tables
Artist:
Artist_ID Primary Key
Artist Name
Albums:
UPC Primary Key
Album Name
Tracks:
ISRC Primary Key
UPC references Albums
Composer_ID references Artist
Performer_ID references Artist
I would like to be able to display the Album Name, Composer name, and Performer Name in the list view of Tracks. I've experimented with some views but I have been thus far unsuccessful. Any ideas?
Thanks,
Mike