Automatically update field value based on input from another table using workflow

[Mayank_Agrawal]

Hi,

I have recently built an app for my e-commerce business which manages order processing. Till now everything seems ok, but I’m stuck with automations where I need some expert advice.

App Description

I’ve got these Tables -

1. Products (Fields- Product Id, Product Name, Type, Price and Image)
2. Sale (Fields- Sale ID, Date, Order ID, Order Status)
3. Sale Details (Fields- Sale ID, Product ID, Order ID and Packing Status)

Problem

I’m trying to change the status of “Order Status” in Sale Table from “New” to “Packed” when I change the “Packing Status” in Sale details Table to “Packed”.

I know this has to be done with actions and workflow, but I’m not sure how to do it. I’ve seen a lot of videos and read a lot about it, still no help.

Looking for solution with steps (if possible). Thanks in advance