Sabtu, 15 November 2014

Re: [MS_AccessPros] Re: Song Database

 

you're welcome, Jerry;) happy to help

Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *



On Saturday, November 15, 2014 7:32 PM, "Jerry bearjercares@gmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:




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: Crystal <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

.

__,_._,___

Tidak ada komentar:

Posting Komentar