User to User messaging system?

[TechieInAK]

There are several threads here about messaging systems. Here’s one that has some ideas as well as links to exampels.

User Messaging System

In my messaging system, I have a table Messages. It has a Subject (text) Body (Text), From (User), To (User), MSGOwner (User) and Status (Text) as the key fields. You can have other fields such as category etc. if you want to allow the message to be ‘stored’ in virtual folders. When a user creates a message to send, two identical message things are created, and each copy is owned by the MsgOwner (1the To recipient, 1xthe From Recipient). This allows the reciever or sender to delete messages w…