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.