>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

The way CompuServe used to do it was they logged the highest message number at the time you login and store that number. The next time you come in, anything higher than that number it assumed you hadn't seen.