Need to change a value of one table to another table


I have a product table and store pickup table.

The business owner updates the available status after a product as should update the store pickup table. - Happening

But i want the product table too should change to bought.

How to do it.

Try creating a relation column between the two tables on a common data column and then use lookup column on that relation.