Linking family members and address

[Rupert_Howard]

Hi, I am using Airtable as a personal CRM and have a table with each person listed individually e.g. father, mother, child 1, child 2 etc. and then details e.g. dob, address (in multiple fields), email etc. I also have a field linking spouse, children, parent etc. However, I am trying to find a way to link the address so that I can update one record when the family moves house (rather than all 4 individually). Any help please?!

[Databaser]

Hi @Rupert_Howard and welcome to the community!

You could use a separate table where the first field is the address (or perhaps the family name) and then use a linked field to link individual persons to the same address. That way, you only have to change the address once when updated.