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!
Novice: Creating Form/Subform to use loading data & querying
-
- Posts: 2
- Joined: Wed Jun 24, 2015 6:27 pm
Novice: Creating Form/Subform to use loading data & querying
OpenOffice 411 on Windows 7
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: Novice: Creating Form/Subform to use loading data & quer
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.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
-
- Posts: 2
- Joined: Wed Jun 24, 2015 6:27 pm
Re: Novice: Creating Form/Subform to use loading data & quer
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?
OpenOffice 411 on Windows 7
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: Novice: Creating Form/Subform to use loading data & quer
No, you are in the right place, but it would be better to see your work if you can attach it.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Re: Novice: Creating Form/Subform to use loading data & quer
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.
- Attachments
-
- ClientNotes.odb
- (19.02 KiB) Downloaded 208 times
OpenOffice 4.01, Windows 7