Novice: Creating Form/Subform to use loading data & querying

[ldbartling]

First, is there a sample CD Collection-type database available somewhere that is fully functional? If I could study & play with it, it might answer my questions.
My Goal: a database showing relationship between Songs and the topics of those songs, so that I can query: 1) what topics are associated with the song(s)?, 2) what songs are associated to the topic(s):, 3)add new Songs/Topics as needed
-Topics could include Christmas, snow, mountains, love, joy, children, father, mother, wedding, graduation, etc.
-Each song can be associated with multiple topics and each Topic can be associated with multiple Songs.
I have 3 tables - don't know if 3rd one is needed:
A) Song List: fields are Song Title, SongID (and various other fields for future use)
B) Topic List: fields are Topic Name and TopicID
C) Join Table: fields are SongID and TopicID (is this needed?)
I have the Songs loaded to Song List Table and have partial Topics loaded to Topic List Table.
How do I create a Form/Subform so that:
I) An existing Song could be found in the Song List and then associate one or more Topics to it
II) A new Song could be added along with its Topics
III) Query a Song and see a list of its Topics
IV) Query a Topic and see a list of its Songs
THANK YOU!

[charlie.it]

Are you looking for someone to do the work for you? Instead if you want to learn, attach a example-file as your database. Someone will help you step-by-step.

[ldbartling]

I want to do it myself - thus my questions toward the end of the post on "How do I create a Form/Subform so that.....". Or, perhaps some of this shouldn't be done on a Form but elsewhere?

[charlie.it]

No, you are in the right place, but it would be better to see your work if you can attach it.

[dpark29]

The attached database has a main form, two sub forms, and a listbox control used to lookup a client and then filter the main form to show only the selected client's information.