I don't know how I missed this for so long... possibly because I don't do a lot of modification of links.

But, when a link is moved from the Validate to the Links database, the values for Hits, Ratings, etc stored in the Validate record (on the date it was moved there) are used.

That means, if it takes you a week or two to make any modification changes, the record you move back to the Links database will be missing the "hits" data.

The only way around this that I can think of, is to add a check box to the "dynamic" fields, such as Hits, Ratings, Votes, etc, and only update those fields if they are checked, otherwise, use the "current" values.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/