Access making tables read each other's mind

[92j...@gmail.com]

I've been wracking my brain around this for some time. So below is my general layout of tables

Product issues
- Statuses (one to many)
- Worker hours (one to many)
- Workers (many to one)

I may have a table design issue but let's find out

My end result is for workers to be able to input their hours from start time to finish time or a status (I also have a table of predefined statuses they choose from too. But if they start working on an issue the original status from before they were working should be added after they finish.

Basically like this

Start status (ss)
Inspection status (is)
Order status (is)
WORK STATUS (ws) (Like removing defective parts)
Order status (os)
Delivered status (ds)
WORK STATUS (ws) (installing new parts)

And so on until everything is finished, but on those work statuses there are workers with hours working on the product. If a worker makes a mistake and needs to change hours they can't cut into other status times except current work statuses and making new ones but if let's say on Monday parts were being shipped but they removed parts I want it to automatically change to work status then back to in shipping. Without adding the shipping status again. And same with deletions; if all workers are deleted from that status then the work status goes away and it's like they were just waiting on shipping. They only way for times to be changed is going backwards and changing the times by hand. Please tell me I made sense lol.