Results 1 to 3 of 3
  1. #1
    compu is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    1

    Help with music collection database

    I would like to create a database for my music collection. I would like to have one table with artist which would be linked to the artists albums table. I would then like a form with a drop down menu displaying the artists. When ever I select an artist I would like it to display that artists album information. I have the tables set up and I have the drop down menu working, but I can not figure out how to connect it with the album information. Any ideas would be greatly appreciated.

  2. #2
    Max D's Avatar
    Max D is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    63
    The easiest way to create form "Artist" and put a subform on it, with his albums.

    Then you can make that form split, to display a list of all artists aside.

    Other ways require some VB coding.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It seems to me that Microsoft has a template already created for that. Either it ships with Access or it OnLine at the Microsoft Office Template site.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Querying Queries for Music School
    By jenny_jumps in forum Queries
    Replies: 0
    Last Post: 01-28-2009, 11:46 AM
  2. Collection of Page Total
    By in forum Reports
    Replies: 1
    Last Post: 12-06-2006, 06:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums