Results 1 to 3 of 3

Help with music collection database

  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,896
    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.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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
  •  
Tech Forums: Microsoft Office Forums