lodmark
Member
- Local time
- Today, 07:24
- Joined
- Jul 24, 2020
- Messages
- 232
Hi!
For some time now, I have been struggling trying to create the best possibility for my database to contain duets without creating duplicate entries in the table for artists (tbl_artist).
The best way to create this possibility I think is with a junction table between the song table (tbl_music) and the table for artists.
In the past I have had the artist table linked to the table for records because it seemed like the best option, see below. Now it needs to be moved and that means that the question (Query1, thanks to @MajP för this one) that governs the subform (frm_record2_subForm2) needs to be redone and this is where I have encountered problems.
Previous view of relationships. Current view of relationships.
Query1 as it looked before. Query1 as it is today, with the junction table.
Query1 works in both versions, except that I can not add new records in the later version where I added the junction table between tbl_music and tbl_artist.
And that's my problem for the moment.
I think I have managed to Google the reason why it does not work. The reason is that there are too many, many to many relationships in the query.
Unfortunately, I have not found a solution to the problem.
When I try to add a vinyl record by clicking on "New record" at the bottom of the form "frm_Record2" I get this picture, I can not add any songs to the record, The box for the subform is empty.
As usual, you will find my database to download if you want to look further into my problem.
Thanks in advance for all the help and wishing you a HAPPY CHRISTMAS!
Leif
For some time now, I have been struggling trying to create the best possibility for my database to contain duets without creating duplicate entries in the table for artists (tbl_artist).
The best way to create this possibility I think is with a junction table between the song table (tbl_music) and the table for artists.
In the past I have had the artist table linked to the table for records because it seemed like the best option, see below. Now it needs to be moved and that means that the question (Query1, thanks to @MajP för this one) that governs the subform (frm_record2_subForm2) needs to be redone and this is where I have encountered problems.
Previous view of relationships. Current view of relationships.
Query1 as it looked before. Query1 as it is today, with the junction table.
Query1 works in both versions, except that I can not add new records in the later version where I added the junction table between tbl_music and tbl_artist.
And that's my problem for the moment.
I think I have managed to Google the reason why it does not work. The reason is that there are too many, many to many relationships in the query.
Unfortunately, I have not found a solution to the problem.
When I try to add a vinyl record by clicking on "New record" at the bottom of the form "frm_Record2" I get this picture, I can not add any songs to the record, The box for the subform is empty.
As usual, you will find my database to download if you want to look further into my problem.
Thanks in advance for all the help and wishing you a HAPPY CHRISTMAS!
Leif