Access 2003

[kajavas]

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?

 

[Ryan]

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.

 

[boblarson]

How about checking out the sample here:
http://office.microsoft.com/en-us/templates/TC010186291033.aspx?CategoryID=CT102144001033
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________