Specifications

Using Databases with ID Works Projects 103
ID Works Standard and Enterprise Version 5 Administrator’s Guide
Only simple variable Production Form fields are available to add to
the database table. Static text, static graphic, and composite fields
are omitted from the list.
You must also select a Primary Key field from the set of text fields you
specified to be included in the database table. The Primary Key field
must contain information that is unique to a given record, such as an
employee number.
You can specify that the Primary Key field you selected should be
automatically incremented for each record added to the database. If
you select Make Primary Key an AutoNumber field, the Production
Form field you selected as the Primary Key field will be Read Only.
The first record saved to the database will have a value of 1 for this
field; the second record saved will have a value of 2, and so on.
If you select an auto sequence field as the primary key, Make
Primary Key an AutoNumber Field will be unavailable.
When you have made selections in each field, the OK button
becomes available. When you click OK, a Summary dialog box opens
that allows you to review your selections and either back up to
change them or finish the database creation task.
When you choose Finish, Create Database from Production Form
creates the database and the table, adds the specified fields to the
table, adds the database to the project properties, opens a
connection to the new table, and connects each Production Form
field to its corresponding database field. If you selected Make
Primary Key an AutoNumber field and if the Production Form field
designated as the Primary Key field was not designated as Read
Only, Create Database from Production Form selects the Read
Only option for that field.
Adding Fields to a Database Created from ID Works
Designer
Developing an ID Works project often involves several iterations. You
may decide to add a field to the Production Form or to add
information to the database that you first thought you did not need to
save. The Add Production Form Fields to Database command on
the Tools menu becomes available after you have created a
database for your project using the Create Database from