I'm working on a form that is connected to a SQL database. The field I'm working with is not a required, and can accept null.
When I pull the record information into my form, I then want to set this field to 0.00. I've tried setting the control in InfoPath to 0, and that didn't work. I've also tried setting a rule so that when the form is opened, it sets the field to zero. That's not working, either. Upon submit, the field remains null.
Does anybody know another way to do this?