Hi all..

I've tried for the past 3 weeks or so in the DBman discussions to no avail..

Can someone please tell me how to modify a record automatically..

I'm running a membership db.. and I have private messaging (records).. When a message is sent.. the status of the message is 'New'.. (No problems here).. now when the recipient views this message.. I want DBman to change the status to 'Read'.. and also to 'Replied' if they decide to reply to it..

So.. I guess I need a small subroutine that opens the 'mail.db' reads in the file.. then appends the '#5 field' (also known as 'New')..

I've tried using examples that i've found from other posts and trying to modify them to suit.. but so far I've managed to delete all my files... delete parts of files.. and delete an entire directory..

The code that I have found that seems to come close to my goals is located here... (slightly altering this code has caused all sorts of wonderful and frustrating things to happen )


http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/001156.html


ANY help is appreciated more than you could possibly believe..

------------------
-----------
millsie :)