Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Creating a Master table or Key

417 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have 25-40 Base’s to build and I need them connected to a ‘master’ base. Internally, our engineers create a table that is a “key”. This key is used both as a Master of unique records and a key for joining all tables. e.g. House# |Issue# | Invoice #…when a new house# is added as a record in the Master table, it would proliferate to all of the other Base’s since House# is a major node for us.

2 Replies 2

Hi Luke,

You can create a “Link to another record” field which will transfer all master information to each of your sub tables based on the matching key value you described. You can also create an automation that will will create a new record in the sub table that will have the master info when a new records is created in master table.

If you need more specific help please do not hesitate to ask any question

It sounds like you want a synced table.