FMP9 Time Billing database - FP9.JPG (0/1)

Please help me. Hello I am trying to make the field Yearto date add
the total when the form is filled out to add the weeks earnings for
every new record when Name is different.Is this possible? When I ,ake
new record for Bobby the Year to date is carried from the previous
record and then add the total when the new record is filled out and so
on and so on But when New record is created Name changes the year to
date is associated with that name. I dont know if I am explaining this
right. Any help would be appreciated. Thank you.