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.
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.