I am new to Infopath. I am attempting to design a form to collect data for a SQL Server 2005 table. I have questions regarding Infopath and required fields.
In designing the Infopath form, a SQL Server database is used as the data source. A SQL Server table’s field is used for a data source in a section containing 4 option buttons (i.e. “website”, “email”, “phone”, “in person”). Depending on which option button is selected by the user, either “website”, “email”, “phone”, or “in person” will be what is imported in the SQL Server table’s field. The 4 option buttons are in a “Repeating Section”, with the Repeating Section’s section properties set to not allow users to insert and delete the section. There is not an option in the properties to make this a required field.
Under Tools > Submit Options > Rules, a rule has been added to show a dialog box message stating “Please complete question #1” if the user leaves the field blank. It is also set to close the form after submit.
When the form was published to a public network drive, the message box does display if the user does not make a selection in the section, but the form is submitted and closed anyway.
How do I force the user to complete the section before the form is submitted to the SQL Server database table?