I went through Stack Exchange - condescending/incomplete/VBA answers, Access Documentation, and 6 videos before your appropriate tone, pace and wording got me to where I needed to be with many-to-many relationships. I didn't know before this video that you shouldn't add more than two tables in the qry! You are the best. Happy New Year!
Best video on this topic that i have found. Only change I would make is to save the query from the combo box in your query list. Facilitates changing later on, such as deciding to sort the genre list alphabetically, or including a definition of each genre.
Honestly, God bless you man. Scoured the Internet for this exact thing and I could not for the life of me find it until i stumbled upon this blessing of a video and I can't thank you enough for real. I wish you would go back to making content so that you can bless us with more great learning material.
This was SO awesome. You actually explain things really well, giving ideas behind why something is done, not just: "do this, do that." Thank you. Subscribing.
youtuber that is right Access did baff with 3 tables :P I wondered howto do this , lots of many many relationship vids , but not related to forms on youtube ......
Great video thanks, I believe the entering same data twice issue would be resolved if you based the primary key on both the book and Genera ID, this would prevent double entry.
Thank you so much for this awesome explanation! How can I create the same for if I want to have a many-to-many relationship between books and authors as well? (then I would have two linkage tables for many-to-many relationships among books/authors/genre).
I went through Stack Exchange - condescending/incomplete/VBA answers, Access Documentation, and 6 videos before your appropriate tone, pace and wording got me to where I needed to be with many-to-many relationships. I didn't know before this video that you shouldn't add more than two tables in the qry! You are the best. Happy New Year!
Best video on this topic that i have found. Only change I would make is to save the query from the combo box in your query list. Facilitates changing later on, such as deciding to sort the genre list alphabetically, or including a definition of each genre.
Honestly, God bless you man. Scoured the Internet for this exact thing and I could not for the life of me find it until i stumbled upon this blessing of a video and I can't thank you enough for real. I wish you would go back to making content so that you can bless us with more great learning material.
This has been EXTREMELY helpful. Thank You!
This was SO awesome. You actually explain things really well, giving ideas behind why something is done, not just: "do this, do that." Thank you. Subscribing.
Thanks for making this video - just what I needed. I really appreciate the fast-paced format - didn't waste my time with things I already know.
Excellent description of a confusing topic, thank you!
youtuber that is right Access did baff with 3 tables :P
I wondered howto do this , lots of many many relationship vids , but not related to forms on youtube ......
Great video thanks, I believe the entering same data twice issue would be resolved if you based the primary key on both the book and Genera ID, this would prevent double entry.
3:10, 7:20 ⇦ Key information here
Thank you so much for this awesome explanation! How can I create the same for if I want to have a many-to-many relationship between books and authors as well? (then I would have two linkage tables for many-to-many relationships among books/authors/genre).
I think you are right on track. It should be possible to simply repeat all of the steps for the author field to achieve the same result there.