Good Day Folks
First time poster here.
I've been searching through your forums for an answer to my question, but I've yet to find it so I'm hoping you can help.
In MSSQL, I have three tables, one holding notification types, another for notifications, which includes an ID, a type (joined with the table Notification Type), the message, the person acknowledging the message, the notification date (when it was sent), and the Acknowledge date (when the person who received the notification clicked ok after reading the message). I also have another User table with the Username field joined with Acknowledger.
What I need to do is, based on certain value changes within certain tables, I need to generate a notification message, log the date created, and when the user for whom the notification is sent logs into the database, have a popup with the notification message and an Ok button. When Ok is selected, the popup closes and the acknowledged date is recorded.
I'm guess I'm just looking for suggestions on how to approach this. I know I need a form to see all of these notifications when logged. I have that. I know I need to make a pop up form that will show the message and when the Ok button is selected, to use the current message id, store the date in the proper record when ack'd and close the window. I guess I'm just confused on how to put it all together.
Any and all help is greatly appreciated.
First time poster here.
I've been searching through your forums for an answer to my question, but I've yet to find it so I'm hoping you can help.
In MSSQL, I have three tables, one holding notification types, another for notifications, which includes an ID, a type (joined with the table Notification Type), the message, the person acknowledging the message, the notification date (when it was sent), and the Acknowledge date (when the person who received the notification clicked ok after reading the message). I also have another User table with the Username field joined with Acknowledger.
What I need to do is, based on certain value changes within certain tables, I need to generate a notification message, log the date created, and when the user for whom the notification is sent logs into the database, have a popup with the notification message and an Ok button. When Ok is selected, the popup closes and the acknowledged date is recorded.
I'm guess I'm just looking for suggestions on how to approach this. I know I need a form to see all of these notifications when logged. I have that. I know I need to make a pop up form that will show the message and when the Ok button is selected, to use the current message id, store the date in the proper record when ack'd and close the window. I guess I'm just confused on how to put it all together.
Any and all help is greatly appreciated.
