Introducing Microsoft® Office InfoPath™ 2003

Adding and Deleting Records

InfoPath’s default New Record button simply clears the form in preparation for adding a new record. Users must type or select required values in the form’s controls and click the Submit Changes button to perform an INSERT operation on the tables.

InfoPath provides a Delete & Submit button to remove the current record. As mentioned in the section “Using the Data Connection Wizard,” earlier in this chapter, deleting a record with dependent child records displays an error message unless the relationship between the parent and child records implements cascading deletions.

Adding New Records

Using a read-only Jet Autonumber or SQL Server identity field to store the OrderID value simplifies adding new records to the Orders ...