You would need to have extra field in the table that you could set according to user actions.<BR><BR>You could have a boolean field called "Read". When your message is created this field is set to false, and when that record has been displayed you set it to true.<BR><BR>Or you could have a counter numeric field, "Counter". When new messages is inserted this field is set to zero. Each time it is read you increment the counter.<BR><BR>Or you could have a date field, "DateAccessed". When new messages is inserted this field is set to null. Each time it is read you set it to the current date.<BR><BR>If you want to create an event log, you would have another table with message ID's, events and date fields. Each time something happens to the message, you add a new record.<BR><BR>Possibilities are endless.