march madness
New Member
- Joined
- Mar 18, 2004
- Messages
- 34
Hi,
I found a template for a music db, and I've decided to use it for my CD database. I am inputting information through forms. It has a Recordings form, where the fields are Title, Artist, Genre, numTracks. Then there is a subform within, called Recordings Subform. It's fields are: TrackNum, TrackName, TrackLength.
It works great when the CD is just by one band or artist, but when I have a soundtrack, or a mix I've made, I've no place to put in the various artists. I'd put "Various" in the "Artist" field of the Recordings form, but then, it would show "Various" as the artist for each of those songs. Ideally, I'd have an "Artist" field within the Recordings Subform that would autofill with the artist name if the "Artist" field in the Recordings form was anything but "Various." If it was "Various," then I'd fill in the names of the artists next to the individual track. What's stopping me from doing this (besides the autofill which I don't know how to do, I'd just copy and paste an entire column)? Setting up the relationships and making the reports. It would seem to me that in the majority of my collection, I'd be repeating a ton of information in the Subform when I have a CD that is not a mix or a soundtrack, since my collection is mostly CDs done by one artist, and not soundtracks or mixes.
So does someone have a good idea how I could tweak the template to elegantly accomodate inputting mixes and soundtracks?
I've seen posts with screenshots of Excel or Access in this forum, and I don't know how to do it. I could point you to the template that I downloaded, and you could see what I mean. If someone would also tell me how to post a screenshot, I'd do that.
Thanks in advance.
I found a template for a music db, and I've decided to use it for my CD database. I am inputting information through forms. It has a Recordings form, where the fields are Title, Artist, Genre, numTracks. Then there is a subform within, called Recordings Subform. It's fields are: TrackNum, TrackName, TrackLength.
It works great when the CD is just by one band or artist, but when I have a soundtrack, or a mix I've made, I've no place to put in the various artists. I'd put "Various" in the "Artist" field of the Recordings form, but then, it would show "Various" as the artist for each of those songs. Ideally, I'd have an "Artist" field within the Recordings Subform that would autofill with the artist name if the "Artist" field in the Recordings form was anything but "Various." If it was "Various," then I'd fill in the names of the artists next to the individual track. What's stopping me from doing this (besides the autofill which I don't know how to do, I'd just copy and paste an entire column)? Setting up the relationships and making the reports. It would seem to me that in the majority of my collection, I'd be repeating a ton of information in the Subform when I have a CD that is not a mix or a soundtrack, since my collection is mostly CDs done by one artist, and not soundtracks or mixes.
So does someone have a good idea how I could tweak the template to elegantly accomodate inputting mixes and soundtracks?
I've seen posts with screenshots of Excel or Access in this forum, and I don't know how to do it. I could point you to the template that I downloaded, and you could see what I mean. If someone would also tell me how to post a screenshot, I'd do that.
Thanks in advance.