I agree that the Ratings/Reviews features are redundant because each allow the user to assign a 1-5 or 1-10 star rating to the same link. This is complicated by the fact that the Rating (Votes) is part of the link's record, while the review is in a separate table. Maybe the designers didn't think any of us would want to use both, or if we want to use reviews we would only want to use them as a separate black box?

What I want to do is take the average 'rating' (i.e. number of stars) from the review and display it with the link on the link or details page. Since I am using reviews, in the interest of Usability, I *cannot* use the 'Rating' feature. So i need to get the average number of stars from the reviews of each link use that.

Here is a solution I just thought of and I'm wondering how to best implement it:

For each link
1. calculate the average rating from all reviews of a link
2. Insert that average rating into the 'Rating' field of the same link

IT would be perfect if this sort of routine could be called everytime I do a build.

Any ideas on how to do this?