mi************@aig.com (Mike) wrote in
news:8d**************************@posting.google.c om:
Hello, I created a form with 3 fields. The objective is to
input all my CD Albums that I have. The 3 fields are, Artist
Name; Album Title; Song Title;...
What I want to avoid is inputing the name of the artist and
the album title more than once. Example: I open the form type
the artist name then the album title, the first song, then go
to the next record, and the artist name and album title are
already there, so that I would only worry about typing in the
names of the songs and not re-typing the artist name and album
title. Then when I'm done with that album, close the form,
re-open it and all the fieds would be blank, but once I type
the artist name and album title of a different CD, the process
will repeat itself, and I would only worry about inputing each
song.
Thanks for taking the time to help me.
Mike
Mike,
Access has some very simple methods of doing what you propose.
However, Access is a relational database system and you need to set
it up properly to do that.
First I assume that your form is based on a single table. You need
to split it out to two separate tables.
The first table, Albums has the following structure:
AlbumID , type autonumber
AlbumName, text
ArtistName, text.
The second table, Songs has two fields
AlbumID, number (long Integer)
SongTitle, text
Once you have built your tables, you set a relationship between
them. The relationship in your case is between Albums.REcordID and
Songs.RecordID, type 1 to many.
You set relationships from Tools->Relationships,
Now you can modify your form to show an album. Remove the song
textbox from the form, and replace it with a subform based on
Songs.
To use the form, navigate to the NewRow Add the Album title and
Performer, then start adding songs.
Access will do the maintenance for you.
Even better, if you notice after entering twenty songs on an album,
you misspelled the Artist's name, you only need to change it once.
Bob Q
