Relationship stuff

message from =?Utf-8?B?Um9iYnZheW5l?= on 19 May 2004
Albums - containing the album title and the artist name (combined being the primary key)
Artists - containg the artist name
Tracks - containing a field called "Track Title", the artist name and album title (which are linked to the table "Albums").

I am trying to make input forms, one for putting artists in (completed successfully), a table for putting in albums for these artists (successfully completed) and a form to link track titles to the albums. I can make a form that means you can choose from ALL artist names and ALL album titles, but I want to be able to limit the album titles to the artist chosen. I think it must have to be done through some kind of looking up but I don't know how to do it. Anyone?
 
Roger Carlson replied to =?Utf-8?B?Um9iYnZheW5l?= on 19 May 2004
"ImplementingM2MRelationship.mdb" which illustrates how to do this.
However, I would suggest that you create autonumber primary keys for you
Albums and Artists tables. It makes the linking table easier to work with.

Also, I would remove the artist name from the album. Don't some albums have
multiple artists? Actually, since each Album can have multiple artists and
each artist can have multiple albums, you need to create a linking table
(call it AlbumArtist). THIS table should be linked to the Tracks table.
 

Archived message: Relationship stuff (Microsoft Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.