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).
@JeffreyHawkins
8 ай бұрын
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.
@BlackheartCharlie
8 ай бұрын
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.
@dunebuggy1
9 ай бұрын
Excellent description of a confusing topic, thank you!
@mightymeto
Жыл бұрын
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.
@farinatty
Жыл бұрын
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.
@TobyReLaXiN
Жыл бұрын
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!
@artistryartistry7239
2 жыл бұрын
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.
@johnbuchanan578
2 жыл бұрын
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.
@seleldjdfmn221
4 жыл бұрын
So nice. what's your favourite drink while making videos. let's be youtube friends? xD
Пікірлер