i need a template to organize songs by artist then song

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to organize a bout 2000 vynle 45 records and i need to alphabetize
them by artist then with 2nd heading under artist for songs by said artist
 
This newsgroup is to answer specific questions, not design the database from
scratch. Get rolling and then post your specific questions.

You will most likely want a table containing the Album information...
RefNumber
Artist
Album Name
Label
Year

The Artist could be a lookup that pulls from another table where the artists
live.

Another table for songs...
Title
Duration
AlbumRefNumber

You might need to consider that a song title could be on several of your
albums.

That should get you started.
 
Back
Top