Specifications

CHAPTER 19 Controlling Updates in Forms
Users Guide 533
Specifying the table to update
Each form can update one table, which you select from the Table to Update box
in the Specify Update Properties dialog box.
Specifying the unique key columns
The Unique Key Columns box in the Specify Update Properties dialog box
specifies which columns InfoMaker uses to identify a row being updated.
InfoMaker uses the column or columns you specify here as the key columns
when generating the
WHERE clause to update the database (as described
below):
The key columns you select here must uniquely identify a row in the table.
They can be the table’s primary key, though they don’t have to be.
Using the primary key
Clicking the Primary Key button cancels any changes in the Unique Key
Columns box and highlights the primary key for the updatable table.