Skip to main content

Linking family members and address

  • December 23, 2021
  • 1 reply
  • 20 views

Forum|alt.badge.img

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?!

This topic has been closed for replies.

1 reply

Databaser
Forum|alt.badge.img+25
  • Brainy
  • December 23, 2021

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.