Sabtu, 15 November 2014

Re: [MS_AccessPros] Re: Song Database

 

Thank you John, Crystal and Mike.  Looking at your recommendations.  As far as I know, yes - there can be multiple composers, multiple songs, multiple albums, but only one copyright holder.  Thanks for the suggestions - hope to get back to you after trying out a few more scenarios.    Sincerely,  Jerry Boor, Michigan - USA

On 11/15/2014 9:03 PM, Sac City Plumbing saccity101@yahoo.com [MS_Access_Professionals] wrote:
 
I would recommend using a many to many relationship.
That would require three tables, for example

1) tblSongs
2)tblComposer
3)tblLinkSongComposer

Mike



__._,_.___

Posted by: Jerry <bearjercares@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Tidak ada komentar:

Posting Komentar