Access 2003

I want to create an access database of my music cd's. Can I create the
database to include the songs from the music cd's?
--
kajavas

You would most likely want to create 2 tables, one called cds, and one called
songs. Add a field in both or your tables called cdname, then create a one
to many relationship on that field where the one side of the relationship is
on the cds table. Then you would make a form based on the cds table, and
then put a subform based on the songs table in the main form using the cdname
field to relate the form and subform. In the main for you would add a cd,
and in the subform you would be able to add every song that belongs to that
cd.
--
Please remember to mark this post as answered if this solves your problem.


"kajavas" wrote:

I want to create an access database of my music cd's. Can I create the
database to include the songs from the music cd's?
--
kajavas

How about checking out the sample he
http://office.microsoft.com/en-us/te...CT102144001033
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________


"kajavas" wrote:

I want to create an access database of my music cd's. Can I create the
database to include the songs from the music cd's?
--
kajavas