- Rule #1 on your Submit button:
- Submit the form to your SQL Server
- Rule #2 on your Submit button:
- Add a condition that checks to see if your "query field" is blank. Then
add the Action: "Set a field's value" where you set the query field value
to the same data field. (In my sample, I have the ShipperID field ...