I'm currently working on a community/forum in written in VFP, using webconnect.

I've got one problem I can't see a simple solution for, hopefully someone can point me in the right direction.

I've got about 1000 users, 10 or so forums, 100 messageboards, and 20,000 messages. When a user logs in, I'd like to highlight any messages that he/she hasn't read.

I can't think of a good algorithm to do it, other than logging each message as read and then comparing the messages against the log file when displaying.

Can anybody think of a simpler way?

Thanks