Create a retrieve on Machine_Log with an xpath constraint on:
Module.Machine_Log/Module.Machine_log_status/Module.Status/StatusId = 1
Then set the text value on the page to Machine/MName over association from Machine_log.
But I think using an autonumber for statusId will not work in your situation, because you don't have control over the value. Depends on your case. Goodluck!