How to Properly Relate Students & Parents in a Microsoft Access Database (and Fix Your Old Records!)

In this Microsoft Access tutorial, I will show you how to properly relate students and parents in your database, create a many-to-many relationship, and fix your old records without losing data. Learn to use append queries, relational combo boxes, and subforms effectively to manage complex relationships.
Darren from Broomfield, Colorado (a Platinum Member) asks: I have my database set up where I have a table for students and a table for parents. Right now, I have two ID fields in my student table to link to two parents. Once in a while, it comes up that I need a third parent (maybe mom, dad, and step-mom). I know the best way to handle this is to create a many-to-many relationship (since parents can have multiple students too), but I've got several thousand records in my database and I don't want to start from scratch. Help?
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Students & Parents: 599cd.com/StudentsParents
PREREQUISITES:
Relationships: 599cd.com/Relationships
Relational Combo: 599cd.com/RelationalCombo
Many-to-Many: 599cd.com/M2M
Append Query: 599cd.com/Append
Subforms: 599cd.com/Subform
LINKS:
SQL with Access: 599cd.com/SQLwithAccess
Concatenation: 599cd.com/Concat
UP NEXT:
Students & Parents, Part 2: 599cd.com/StudentsParents2
RECOMMENDED COURSES:
Access Relationship Seminar: 599cd.com/RelationshipSeminar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database,, many-to-many relationship Microsoft Access, relational database design Access, Access join tables, linking students to parents Access, multiple parent records database, Access database normalization, junction table in Access, Access append query tutorial, relational combo boxes Access, Access subform tutorial
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@Shadow.Dragon]

Great video, Richard! I always think "query" so I end up with a "ton" of queries! I need to flip my thinking to "SQL"!

[@alializadeh8195]

Thanks

[@boerinbeton7052]

Thanks for the video.

[@stephenbeswick2163]

Hope you are keeping well since you have man flu hope you are ok steve B