Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004

    Unanswered: Very Basic Database Help Needed


    I'm new to creating databases and am having trouble doing what I think are basic things. For my first project I wanted to create a database of my CDs:

    Created tblAlbum -> AlbumID (key), Title, ArtistID, Year, etc...
    Created tblArtist -> ArtistID (key), FirstName, LastName

    I linked the tables by ArtistID and am trying to create a form to enter new CDs. But I'm stuck on entering the artist. Is it possible to create a field in my form where I can either select the artist from a list (or type the first few letters and have it jump to the right artist) and then have it fill in the ArtistID automatically? Also, can the same box allow me to enter a new artist and have it auto-assign a new ArtistID in tblArtist?

    Thanks in advance!


  2. #2
    Join Date
    Feb 2004
    I just wanted to add that if someone knows a good website where I can learn about this stuff myself, I'd appreciate the pointer.

  3. #3
    Join Date
    Aug 2003
    Cleveland USA
    I used Learn Access in 21 Days. Create a query of all Artists' names, then on your form, create a combox box with the query as the recordsource.

  4. #4
    Join Date
    Sep 2004
    Tampa, FL
    At the risk of sounding sarcastic Maelwys in Access just press F1.
    Also look here and here for some general Access stuff.
    Do not forget to learn SQL here is a start.
    Lastly the MS website is a wonderfull resource. If there is one thing MS does well for the user ,in my opinion, it is that they have good help files and wonderfull web help. Have fun !

Posting Permissions

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