|
||||||
|
Students & Parents By Richard Rost 5 months ago Relate Students & Parents in MS Access Database 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? MembersThere is no extended cut, but here is the database download: Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! PrerequisitesLinksUp NextRecommended Courses
KeywordsTechHelp Access, 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
|
||||||||||||||||||||
| |||
Keywords: TechHelp Access, 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 appen PermaLink Students and Parents in Microsoft Access |