Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Thanked 0 Times in 0 Posts

    Tracking chart history (97)

    I want to build a database to track the progress of Singles and Albums. The singles will also appear on the artist's albums as well as compilation albums. The problem is, I need to store all the information about current and all previous chart positions. I'm not sure how to start?!! Any initial suggestions would be very much appreciated?

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Cheadle, Staffordshire
    Thanked 0 Times in 0 Posts

    Re: Tracking chart history (97)

    Perhaps this will give you a start.
    Its a basic layout of Main Form and Sub Form.

    The main link is ID, with tblAlbum holding the primary key.
    By using the autonumber in this way, the system won't let you duplicate the Album Name, but, you can have a duplicate Single associated to various Albums.

    Good luck if it gets you on your way.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts