I think the error you are receiving is because the record ID you reference in the Update Record step is for a record that is in Table A, not Table B.
How are the records in Table A and Table B related? Are they linked to each other? Or do they duplicate some information without being linked?
I think the error you are receiving is because the record ID you reference in the Update Record step is for a record that is in Table A, not Table B.
How are the records in Table A and Table B related? Are they linked to each other? Or do they duplicate some information without being linked?
When I change the status in table A, a record is created in Table B with a 'link to another record'
That is the only relationship between them
When I change the status in table A, a record is created in Table B with a 'link to another record'
That is the only relationship between them
Okay great! If they are linked, then in the Update record step, you want to select Table B as the table, and the Record Id should be the link to Table B field coming from the record in table A that triggered the automation

If you want to change the status in Table B *any time* a change is made in Table A, you could change the automation Trigger to be "When a record is updated", with the automation watching the status field in Table A, and configure the update record to dynamically update the status field.
