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 online now Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,914
    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
  •  
Other Forums: Microsoft Office Forums - Senior Forums