Detail Tables To Master Table

Hi There
I wanted to tell you in Attached pic.:
Dates compare in Detail Tables and which current date (new date) then the detail table 'Durumu' field goes to TumIsler (master Table) 'SonDurum' field.

How Do I make this

Pls help me..
Picture1
Picture2