Notification Tickler

[frisch]

I have two fields (Order_Status, Quote_Status) and each of them is populated by a value list item selected by the user. The default setting for each field is "Quote". Once the Quote_Status is changed to "Approved" I would like to be notified in some way. The user is entering her data via IWP and after clicking submit the change is committed to the DB, but I can't figure out how to have it let me know she has changed the field to "Approved".

I am often times out of the office on sales calls and I forget to look through all of her orders (50-75) to see which ones have changed. And she forgets to email me all of the ones she has changed. Remember, she is using IWP.

On a side note, when she does change "Quote_Status" to APPROVED it is also supposed to change "ORDER_STATUS" to "WAITING ON ART". It works for me on my desktop app, but it doesn't update via IWP.

Sorry if this is two questions at once. I am very frustrated.

Thank you in advance for any help you can offer. I am SOOOO glad I finally found this forum to help me.

Frisch