If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Access 2003
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 |
#3
|
|||
|
|||
Access 2003
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 |
Thread Tools | |
Display Modes | |
|
|