Update a row on another table only based on the row in another table

[tu22]

I have two tables:

Tb1

Batch	Meter	Date	status
Batch 1	Meter 1	31/10/22
Batch 1	Meter 2	31/10/22

Tb2 

Batch	Meter	Date	status
Batch 1	Meter 1	31/10/22	loading
Batch 1	Meter 2	31/10/22	In progress

I want to update Tb1 status with Tb2 status where Tb1.Batch = Tb2.Batch & Tb1.Meter = Tb2.Meter 

so Tb1 becomes row 1 

Batch 1  Meter 1 31/10/22 loading.

I created a custom form that patches data to Tb2 but based on the status update from Tb2, I want to update the status column of a specific row on Tb1 where the batch, meter and date on Tb1 match

how do i achieve this using the patch function

[tu22]

@Reza please could you help with this?

[tu22]

@RandyHayes please could you help

[tu22]

@mdevaney please help with this

[tu22 · Accepted solution]

I solved this, anyone who needs the solution can leave a comment