Xataface Forums

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