Sounds like you need this data model:
Household::__pkHouseholdID = People::_fkHouseholdID
You'd put your address fields in Household and link people (such as spouses) to the same Household record to show that they have the same address. Address fields from Household can be added directly to the People Layout and members of the same household will have the same address in common.
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
I currently have people connected to a Family (which would work as household).
I have the Contacts table which has a __pkContactID
I have a Contact_Family table which has _fkContactID and _fkFamilyID
I have a Families table which has a __pkFamilyID
(Not quite sure it was setup this way, but I think it has to do with creating a portal... I was following an online tutorial, or an answer from you in the forums, but it was many months ago).
Contacts ----< Contact_Family >---- Families is my current relationship setup.
What's the best way to get my current addresses from one of the family members to the Families table for hundreds of records?
I figured out an answer....
I created a script that copied from the Contacts Street/City/ST/Zip and pasted to the Family Street/City/ST/Zip.
Then, I created a button on the individual records page that triggered the script.
I am still doing it manually (or a little bit of control, and for the few outliers who don't have the same address).
Thanks so much!
Is a many to many relationship that makes it possible for one contact to be a member of more than one family. That may or may not be a required capability for your system.