Actually,
@alwaysbusy already had the solution in the feedback app - my old brain just could not comprende... until a second look.
Logic is in feedback app - so I won't repeat it here.
' reset everyones read status for this case (except the current user)
DBM.SQLDelete(SQL, "DELETE FROM caseread WHERE CaseRCaseID = " & ActiveCaseId &" AND CaseRUserID <> "&UserID )
I added this: &" AND CaseRUserID <> "&UserID - so the current user who added a new note would not get notified that there is a new note... Noted!
I shall use the same above in the Update cases and attachment tables code. Now, any user (other than the current who posted) will get notified of new issues when someone else adds / modifies the content.
Admin - as an administrator, you need to know when someone updated a case, without reviewing each one - looking for something new...
User - as a user, you need to know when Admin (or other) updated the Status, added/edited a note or posted new attachement - without reviewing each one - looking for something new...
This added functionality can not be overlooked or overstated - it is imperative (in this design anyway).
Note:
Without all of you intelligent people in this community contributing (rather than just consuming) - complex / important issues like this would not get resolved.
Hats off and a big bow to you contributors!