Access 2016 - Relationships - How To Create One To Many Relationship in Database Between Two Tables 

Thank you so much... Access has been giving me headaches

Thank you so much! Very clear, concise and to the point. Better explained than my teacher

Could not understand what my textbook was trying to say. Thank you so much for making this simple and easy to understand. Total lightbulb moment!

This is like the 10th tutorial on relationships, and the first one presented in a way I can understand. THANK YOU!

currently studying for my access midterm and this is amazing!! you’re a true legend

Thank you so much for your tutorials! My class went online recently and your lessons are a tremendous help!

Thanks a lot for the help. I was getting increasingly frustrated figuring out how to properly link two tables in a one to many relationship. It was easy to follow along with you here!

U just saved me from alot of headaches. My trouble was not putting the field as a primary key and then I noticed one of your fields as a primary key, Got it!

Thank you so much. Watching your tutorial help me so much, better than the current instructor I have now.

Great video bro. I have a certification exam for Microsoft Access tomorrow​ and your videos are extremely helpful.

Thank you so much for, quick, precise, to-the-point info. In under 8 minutes. A lot of the videos I click on for tutorials are hours long. That's just not practical and a lot of the times they mention things that I don't need to know, therefore making the video longer than it needs to be imho.

IN A FEW MIN, I LEARNED MORE FROM YOU THAN FROM MY PROFESSOR

WISH I FOUND YOUR CHANNEL EARLIER. Haha I'm studying last minute for my exam and been going through videos all day, yours really have everything i need! Thank you so much!!

excellent tutorial. had to watch this to do my assignment because my lecturer made this seem so complicated. Thank you!

Thanks a lot professor Adam, I have my 8th grade computer practical exam tomorrow and it helped me a lot. Thanks

Man u saved my tomorrow's IGCSE exam, thanks a lot

Great video. I'm taking an Access class for school, and I was a little lost. Your video really helped.

OMG, could you be my professor you have helped me out from a teacher that does not teach at all and uses youtube as his teaching method. Your explanation got me an a on my report.

I can’t express how much I appreciate you bro!

I was having a hard time with access, this tutorial helped me a lot, thanks

thank you so much! I am new to Microsoft access and I needed to complete an assignment for my business class. This was extremely helpful!

Dude. You helped me solve a problem I have been trying to figure out for days! Thanks for the easy to follow instructions!

Thank you ! I have my AS IT exam in a few days and this really helped

I’m not even an English speaker but this video has really helped me! Thanks a lot

Broooo Thank you so much I'm a IT Major and one of my classes is computer applications and we have a Microsoft access assignment where we had to do all this bull and you helped 🎉🎉🎉🎉 you rock dude

Thank you for this. You saved my life. Tomorrow I am appearing for my computer exam. Thank you

IVE BEEN TRYNA FIGURE THIS OUT FOR MY CLASS THANKKK YOUUUU

best and simpleste explanation ever made

Thanks for this. I passed my long test because of this video.🎉

Thank you, very easy to understand, I was flying at first, then got unstuck with the primary key but your videos and playlists are helping loads. Really appreciated.

love love love your no nonsense - lets get it done approach - you saved my life with this one lol

Thank you so much!! I HV an exam on access in less than 2 hrs and this is def going to save me..

Thank you for keeping the instruction to-the-point. I tried watching videos by another RU-vidr (Kirt Kershaw), and despite his thorough instruction, I found his videos to be intolerable because he tends to drag things out more than necessary.

Legend and saviour, your channel is gonna help me ace my course

This helps a lot bro this video was explained well, i have an exam this Monday so my knowldege has improved thanks a lot, i couldn't get access on mac so luckily i'm using my Dad's work laptop that has access on it to practise man i was so stressed thank god for this Channel and this video.

You are a very good teacher. Cheers!

Thank you for your video. I'm dating myself but I used to make DB's with DBase III as well DB Programs with Clipper. I am trying to get up to speed on this new format that MS uses and your tutorial really helped. Concepts are basically the same its just a new approach to getting things rolling. THANK YOU.

Thank you soooo much! I wish I found your channel 7 weeks ago when my course began! I am having trouble getting my short-text survey responses, imported from Excel, to translate into additional tables in Access. All of your videos have helped me tremendously, especially query writing and relationships! THANK YOU!

Nicely done! Your presentation is very clear. Thanks

Very helpful for someone That is Learning all of this but is also wanting to do it better so I can be successful with my Results

This is a great video! The only thing that I would suggest is that you be careful with regards to how you refer to the “Cascade” option. It does not refer to adding a sub table in your table. It actually refers to cascading the changes that you make throughout child tables. I only point that out because you also checked the cascade delete which will delete, everything related with a record throughout your database (and cannot be undone) when you delete it as does making a change to something you cascades the changes down to all of the other records that it affects. Other than that is an awesome tutorial.

thank you so much this helped me a lot, i kept forgetting how to make the infinity sign and the 1 appaired on the relationship, but now i understand how to do it. thank you very much sir.

يا رفاق ادعوا لي أجيب درجة ممتازة في الاختبار💗 Thank for gad I found your channel I was confused about one to many relation sheep but now it is clear for me thank you so much for working hard and keep going 💗💗

Thank you so much. It sure has helped my gradual understanding of the relationship between tables in ACCESS.

Great overview. The thing that would make this perfect is to discuss the primary key.

You really teach very well.. Thanks a lot, it helped for my exams

THANK YOU VERY MUCH I needed so much help other youtube chnnels were very complicated

Fantastic explanation, mate I’m lying in bed watching this at 6am and now I have the insatiable urge to migrate all the data from my expense logs and client spreadsheet into Access yep I’m that kind of weird

Thanks Adam, I'm confident I'll ace my exams now, Subscribing!

Thanks for such a clear and concise explanation! It really clarified the concept for me.

Thank you Adam, very clear and appreciated. I was wondering if you had an UNF table and wanted to go through 1NF, 2NF, 3NF (Normalized) - can you please show how this would work please regarding the relationships and how to implement it. Thanks again :)

You did a good job. I’m completely spasticated with computers, and this helped. Thanks.

Very well explained ! Simplified a complex activity

thank you so much.....this helped me and cleared all the confusion i had thank you so much may god bless you

These videos are amazing and extremely helpful, thank you so much!! I'm preparing a database, and I was wondering if it would be possible to link two tables without using the primary ID. The "teacher name" field of one table (Student Information) is a lookup field taken from the teacher name field in the teacher information table. Unfortunately, the relationship was not created and is not visible when I click on the relationships tab, despite the lookup working fine. Can you please tell me if there's a way I could relate both tables without using the primary keys? Thank you, Angela

Thank you straight and to the point with valid information

Very helpful! I am new to Access and trying to learn on my own. This really helped make it clear.

This video was so helpful in order to submit an assignment on time. Five stars from me *****.

you made it so simple thank you so much!!!

Sir, Your teaching is amazing and very understandable! You are Amazing and I just subscribed and looking forward to your videos.

excellent Explanation , thanks a lot please continue to provide more lesions

You're beyond awesome! So grateful for your page.

Very clear explanation, help me a lot. Thank you.

thanks bro u have helped me with my KCSE computer project in Kenya 2020

this super helpful even today

a giant thanks for explaining this mystery!

this helped a lot professor thank you, I just subscribed

Excellent tutorial, thanks

Wow that was really helped because I had an assignment today and I was stuck on that question so I can correctly done it a bunch of thanks really appreciated 🥰😍

HI PROF..I LIKE YOUR WAY TO EXPLAIN...PROF WOULD YOU PLEASE DO AD ADVANCE ACCESS TUTORIALS.

My IQ level is not high but I got the lesson thank you. I usually don't comment I should say your way of teaching is spatial.

This is amazing. I am currently working on a customer database and this video has given me more understanding. I have a question: I have customer table, transaction table, Bank information table and cheques table, how do I link these tables to my Customer table?

Terrific explanation. Thank you!

Excellent Explanation, I love you.

This is actually a very helpful and great video sir...!!!!! You are just great!!

Video was very helpful. Thank you

Excellent explanation.

Awesome videos! Thanks!

Thanks man! This was really helpful

Good stuff right plain and simple, straight to the point cheers!

This video was awesome! Thank you so much!

Thank you so much for making this video, it helped me a lot for my bpc 110 class.

Excellent. Very helpful. Thanks. Please prepare video on MS Access VBA coding.

Thanks alot, this session really helps

Thank you The way you explain it very good

I...I think I love you lol. Thank you soooo much for this video!!

Good video, very helpful and well executed.

Thank you...keep up the good work.

Very good video. Helped me a lot!

hey - thank you for the tutorial. have learnt so many things here, though I still got a question, "is it possible to create a relationship between 2 fields which seem to have no direct linkage?" I have got a headache with my project documentation

thanks Dude you help me i have home assignment great video and good work

Great video, thank you. I'm trying to link a 'Projects' table with a 'Tasks' table, where multiple tasks occur in a project. My tables are linked after following your instructions, however my Projects table shows all entries from the Tasks table, not just those with the linking ID. Any ideas?

Well explained! Thanks for your help!

I highly requested you make stock control tutorial video from product table, customer table and suppliers in Microsoft Access.

Nicely done! Thank you.

Yoo thank you so much for this vid! Just helped me with a final step in my database exam!

nice work dear friend , i like , nice share , stay connected

Thank you, Professor Adam Morgan! Your tutorial has a great pace and your teaching is SO clear! Subscribe!

In a professional database the PK should be a single column integer that is not updateable so update-cascade is not needed. There are reasons to use the same advice for intersection tables (that enable many to many relationships) as well.

Can you help me create a relationship for a list of clients then under each client, a list of websites and sign on info? Very similar to what you did in this video I'm just hung up on the relationship part. I created a Client ID for a Client Table and Website Table but maybe I have the primary key messed up. thank you love your videos!