Displaying the most recent records score on a custom object, on a parent object

Hi Guys

Is there a way of populating a field on an object, with a value from another object, but only the most recent record created on the object?

For example;

I am creating an at risk score card, which will be linked to the account object, what I need to happen is, when a new record is created on the at risk object, I need the score of the record which will be a custom field to display on the account object, but each week when a new record is created I need the latest records score to populate the field on the account object overwriting the previous weeks score, hope this makes sense :S and is this even possible to do :S

Many Thanks

James