How to Store Multiple Addresses for a Customer in Microsoft Access, Part 2

In this Microsoft Access tutorial, I will show you how to manage multiple addresses for a customer by using separate tables and establishing key relationships. You'll learn how to design an operational structure to differentiate between address types like billing and shipping, and incorporate combo boxes for dynamic data interaction. This is part 2 of our series.
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Multiple Addresses 2: 599cd.com/Mult...
PREREQUISITES:
Multiple Addresses, Part 1: 599cd.com/Mult...
LINKS:
Intro to VBA: 599cd.com/Intr...
Compile: 599cd.com/Compile
UP NEXT:
Multiple Addresses, Part 3: 599cd.com/Mult...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$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/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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,, storing multiple addresses, address table setup, customer form customization, address type table, relational combo box, foreign key management, database design, combo box tool, address form layout, entity relationship, tab order customization, list items edit form, many-to-many relationship, data entry optimization, debug compile, VBA troubleshooting, Access design tips, user interface customization, address type combo, multi-address handling
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@Shadow.Dragon]

Great series! Onward to the next video!!!

[@alializadeh8195]

Thanks

[@RelaxingMusic-ts9xx]

Thanks for sharing ❤

[@donaldshroyer8633]

Instead of a single address type field, I'd suggest multiple check box fields so any address can be more than one type. But of course that is more difficult to edit if more types are needed.