How to update the status from the Reference Table in the data

I have 3 Tables - Product, Design and Orders ( Images Attached)

Now I want to get the Design status of the Order from the Product Table and Design Status of the Product from the Design Table . But whats more crucial is to update these status as and when they are changed in the reference table.

For Eg. Whenever I Change the Design status of a Particular Product from The Design table, the Design Status Field in Product Table should get updated. Likewise ,Product Design Status in the Order Table should also get updated.

How is that possible ? Plz refer the attached images