Trying to update data in RMS with a web interface

My project is much more complicated, but I am hoping someone can give me some generic tips and/or code to assist me.

I want to update a field in RMS with some data the cashier inputs on an HTML form. For example, if a cashier selects a customer using F7, I want them to press a custom button that brings up an HTML window. That html file will have a form where the cashier will enter some text in a textbox. When the cashier presses Submit, the text in the textbox will be written to the Customer.CustomText1 field.

The two major issues are 1) how to pass the Customer.ID to the HTML window and 2) how to execute the SQL to update the Customer.CustomText1 field from the form data.

Reply to
Jason
Loading thread data ...

Wow, that's a big one. Look in the RMS customization guide for the QS rules object description. We usually do that type of thing in VB, you might consider that.

Reply to
JerryData

Jason, It may be easier and less error-prone to invoke an actually application from the POS button rather than an HTML window. QS Bridge is kinda flaky at times.

Reply to
Ryan

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.