March 14, 200718 yr Newbies 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
Create an account or sign in to comment