Joining 3 Tables

Archived from the Xataface Users forum.

mikep — Sat Aug 08, 2009 1:37 pm

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