question about access...

[Bill James]

Jeff,

The solution is to have multiple tables with
relationships which you define. A table for
say "Artists", then "Album", and them "Tracks"
or "Songs", or something like it.

Each table must have fields that associate with the other
tables such "ArtistID", "AlbumID", and "TrackID". With
this schema, you can add unlimited (up to DB limitations)
artists, albums, and tracks.

Then you would create a Form or Query to extract the
information you are looking for.

A full description is beyond what can be written here,
but I suggest you look at some of the sample databases or
get yourself a book on the topic.

 

[Larry Daugherty]

I did a similar music library in Access 4 or 5 years ago. One thing I did
that saved lots of typing was to use a combobox with a NotInLIst event for
the entry of the song titles. Once you get the first hundred song titles in
you'd be surprised how many times the same title comes up - from Western
through classical.

hth