>>I would create a table with 4 fields -- FromUser (Char), ToUser (Char),
>>Message (memo field), Received (logical). Setup your app to automatically
>>query this table for the ToUser = UserID that just logged in (from your
>>Security system) and Not Recieved. If there are any new messages,
>>automatically display them in a form with an option to review previously
>>*received* messages. After the review a message, set the Received field to
>>..t. I would also add a menu item to allow the user to access his/her
>>messages at any time as well.
>>
>>Of course you will have to add a procedure to create new messages for the
>>table.
>
>I've had another thing, if it may help. There was a system with some 40
>users, and ocassionally there was a need to distribute system messages.
>The users were doctors who worked with varying schedules (not same time
>of day or even week), so I've combined the LogIO table (who logged in,
>when, where) and the message table, which had just a timestamp and memo
>with text. Simply checked for new messages since the last login and
>shown them.
Thanx Mark
I will use that varying schedule Idea somewhat- Ed B
Edgar L. Bolton, B.S. B.B.A.