setting up relationships

[prev] [thread] [next] [Date index for 2004/06/21]

hello list--

i am having some trouble setting up relationships for my database, which
has a fair number of "lookup" tables.  given these tables, i'm wondering
how i can setup a relationship between them.  also, any advice on how to
use AutoLoader in this scenario would be great.

table track (
	track_id int,
	track_name varchar,
	... etc.
)

table artist (
	artist_id int,
	artist_name varchar, 
	... etc.
)

table track_artsit (
	artist_id int,
	track_id int,
	primary key (artist_id, track_id)
)

in this scenario, a track has n number of artists, and an artist might
have produced x number of tracks...

any help greatly appreceiated!

thanks
steve