I've recently begun working with InfoPath 2007 so my experience is limited.
I have a form built that uses one data connection to one table in a SQL database. I've enabled Submit features on this form. I also have all fields from the table being retreived by the data connection.
The situation is that I only want the user to enter necessary fields and not have to enter values for fields that are required by the database design, but really just store default values.
I'm planning on using VB.Net to code additional data submission logic into my Submit event handler.
I'd like if it's possible to add code that will update the values for these additional fields I don't want to force the user to enter these fields. I thought about adding these fields to the form, making not visible, and applying default values, but would rather do in code if possible.