Count Good Inventory when submitting.

[Cooptoons]

We use infopath and access to keep track of the parts we repair. For each
part we track part number, serial number, problem, repair, condition, ect.

Is there anyway to count the number of good parts in stock and have an email
notification sent if the quantity is below a certain value when you submit?
So what I would like to do is submit the changes made to that record, check
the quantity for that part number, if it's below a certain point have an
email sent to notify.

Thanks in advance because you guys have always come through in the past.

 

[S.Y.M. Wong-A-Ton]

I'm assuming that your form is bound to the database? If submission to a
database using rules worked, you could just add another data connection to
submit an email and then use a rule to submit to this data connection when
the condition of good parts in stock were met. But since submission to a
database using rules does not work, I'm afraid you'll have to code the entire
logic in the OnSubmitRequest event. It can be done, but requires code.

Look into using the OnSubmitRequest event
(http://msdn.microsoft.com/library/en-us/ipsdk/html/xdevtOnSubmitRequest_HV01021370.asp?frame=true).