Database Connectivity - Insert Record Action

To process input from a web browser request when adding submitted information to a database, use the "Insert Record" action from the database toolbar.

Start by creating a data connection and a recordset using the "Database" toolbar, and then design a form to accept the information. Choose the "Insert Record Action" option - you can select your connection name here.

Select a table from the list, and then list below will populate with database fields.

A list of form fields will be presented in a list, where each database field can be matched up to a form field by double-clicking the entry. You may wish to leave some form fields blank, but this is up to you.

Choose "OK" when you are ready to insert the code.