Automatically link records in two separate tables when added as new records in a third table

[Stu_Smith]

In one base I have three tables. One is for Manufacturers and another is for Products. Manufacturers records have a field that can link to multiple products from the Products table.

A third table is for special offers. The data is imported here from a separate list and it includes linked fields for both the Manufacturer and the Product.

When a record is added here it will add the Manufacturer and Product to their respective tables, if they don’t already exist. But it doesn’t automatically link the Product to the Manufacturer.

Is there any way to make that happen?!

[Stu_Smith]

I got there manually by copying the Product and Manufacturer columns from the third table and pasting into the Products table. Not ideal and I’ll probably have a fair few duplicates now… automatic would be better!

Thanks for anyone’s help. :grinning_face_with_big_eyes:

[Rose_K]

Hello and welcome to the Airtable Community @Stu_Smith!

I’d recommend looking into Airtable Automations as a recurring automatic solution to updating your records.

Utilizing Automations you can:

1. choose a trigger (in this case whenever a new record is added to the special offer table)
2. add an action (one of the actions will allow you to update a record)

Using Airtable Automations should allow you to have a fully automatic workflow. :star2:

[Stu_Smith]

Oooh… ok that all looks very interesting. I’ll dive in and see if I can work it out!

Thanks. :slightly_smiling_face:

[Rose_K]

Let me know if you have any additional questions as you dive in!

Also if my response answered your question could you do me a favor and mark the answer as a solution using the :white_check_mark: ?