Copy to another table, then update record with automation

[Hearth]

Here is what I have managed so far:
• In the first table, when I confirm that the record is eligible through a single-select option, I have been able to:
1. Copy it to a second table dedicated to Marketing.
2. Copy it to a third table dedicated to the Backend.

What I am unable to do is:
1. When I activate a trigger in the Marketing table, I would like the record to update in the Backend table as well.

I have tried both reproducing the tables manually and individually copying the columns and using the "link to another record" function with tables in lookup.

The error I encounter is that sometimes it doesn't find the record, and other times it indicates that the input entered is not feasible.

In the end, it just needs to update a single-select field, nothing complicated. 🥹

  

[TheTimeSavingCo]

Hmm, I'm not too sure what's wrong with your automation, but here's a working example setup of what I think you're looking for:

And you'll have to change the display to ID like so:

And here's a link to the base so you can view the automation

[Hearth]

maybe my error is to create a copy of the previous record?

For example, on the first Table I created this automation, but I want that even between Table 2 and Table 3 there's a connection to the same Record.

So I would that all the Table use the same record, some with more record column, other with less, other with different one. (because one I want to use for Marketing, so for example it needs more on contact information. When one of it is "accepted", and so I received the payment, I would like that the marketing team could change the status so on this change it will update the record on Backend table