Access 2003

K

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?
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top