Messages Recordset

Hello Guys,

Can you help me please, if you received a messages you can see the total messages that you

have. But when you read that message. The total of the messages you have is decreasing.

For example:

In my Inbox Messages I have (10) New Messages ... but when I read one of that (10)

messages. And When I go back to my list of messages. My total messages should be

(9)Messages because, I already read that message so it should be decreased.

(NOTE: THIS IS MESSAGES IS CAME FROM MY DATABASE TABLE,. I Used here the Recordset and Filter the Messages that the user owned)


How was that ?

Can you help me please regarding my problem ?

-------------------------------------------------------------

Thanks In advanced ....

your message table will need a column to mark the messages as being read or not.

Set the initial value for this column to 0


when the user reads a message, you need to update the column to 1

on the page where you display the number of messages, set the recordset to only query records where the read column is equal to 0

Hi Jason,

How could I update that value in that column If I only used a link, should I used a form to

update the read and unread messages.

-------------------------------------------

So, You mean there are two recordsets, which is the view the unread messages which the query is = 0;

and the another recordset for the is for the read messages which the the query is = 1

Is that that what you mean ...

Thanks

your link to the read message page will pass the message iD as a querystring parameter. use the querysting variable in the update record behavior.

In the DA-Single Record Update,. In the Record Fieldset , the textfield with the lightning bolt

,.. what value should I put there ?

Thanks

I dont follow your question.