In this video, I'm going to show you how to use two subforms to browse related records using an intermediary parent form. This will allow you to see a set of parent records in one subform, you can click on one, and then see the list of related child records in the second subform. For example, we'll see a list of starships and their crew. The same concept works for categories and products, customers and orders, employees and timecards, etc.
LEARN MORE:
599cd.com/SyncSubforms
PRE-REQUISITES:
Relationships: 599cd.com/Relationships
Relational Combo: 599cd.com/Relational
Subforms: 599cd.com/Subform
Link Master Fields: 599cd.com/LinkMasterFields
RECOMMENDED COURSE:
Access Expert 3: 599cd.com/AC10X3
LINKS:
Continuous Forms: 599cd.com/Continuous
Many-to-Many: 599cd.com/ManyToMany
Value From a Form: 599cd.com/FormName
Disallow Editing Data: 599cd.com/AllowDeletions
BECOME A MEMBER:
RU-vid: / @599cd
or My Site: 599cd.com/THMember
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$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
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, Synchronize Two Related Subforms, How to Link Two Subforms, Multiple Subforms, Synchronizing Multiple Subforms, Synchronizing Two Subforms, link subforms, ms access multiple subforms example, access link subforms
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
6 авг 2024
