Capture value of field from related table, but only at that moment

I have a parent table called Requests with a field called Status. I have a related table called Log with a field called Log Status. At the time I create a new record in Log I want to capture the cu...