Automation that when a record in table-1 is created, a record in table-2 is automatically generated

I would like to create an automation that when a record in table-1 is created, a record in table-2 is automatically generated. And the key field in table-1 is copied over to Key field in table-2. I hope this is a fairly easy automation. I appreciate your help.

This is possible with automations, but is there a specific reason for why you want to do this? Most people who think they want this actually just need to create separate views in a single Airtable table.

Because I am used to creating a master table with detail table. Where the customer has a table and the and the customer has a detail table.

I wouldn’t recommend that approach. That’s precisely what views and interfaces are for.

You can also expand a record to get an instant detailed view.

Yes this is a pretty simple automation but with a flaw

Trigger on new record created

Action - create new record with using fields from the original record to complete the fields from the other - however

Be careful as doing this may trigger the auto,action before you are finished adding data to the new record

So choices are - to have a field day a tick box to mark the completion of the new record creation or to complete these by for, or to change the trigger to be about going into a view

Or

Maybe better sync record to a new table and only sync the fields you want to use.

This last option is something we use to manage specific projects with records where there may need to be a project specific base.