Specifications

Connecting Fields 101
ID Works Basic Version 5 Administrator’s Guide
Data Source Area
The data source you specified in the Data Source tab of the Edit
Project Properties dialog box appears in the Source field. The Table
field shows the name of the database table or, if the data source you
specified has more than one table, it lists the names of the available
tables in alphabetical order. You use this list to select the table you
want to connect to.
In the Column field you will see the names of the columns in the table
specified in the Table field. The column names appear in alphabetical
order. If you click on a column name that is connected to a Production
Form field, a line appears showing the connection.
When you connect to multiple tables, make connections to the parent
table first. When you connect a Production Form field to a column in a
child table, ID Works Designer adds that table’s primary key columns
and any columns related to the parent table via foreign keys or
common column names. ID Works Production will insert or update
information in these related columns automatically when a record is
saved. See “Connecting to Multiple Tables in a Database” on
page 86.
Production Form Area
The name of your Production Form, specified in the General tab of
the Edit Production Form Properties dialog box, appears in the
Design field. Below that, the names of the data input fields in your
Production Form are listed in alphabetical order.
Production Output Area
Choices for the Type field are Card and Report. If you select Card,
the Design field shows the name of the card design for your ID Works
Basic project. Because ID Works Basic is limited to one card design
per project, the card list will never have more than one entry. In the
Field area, the names of card fields that will change from card to card
appear in alphabetical order. If you click on a card field that is
connected to a Production Form field, a line appears showing the
connection.
If you select Report for the Type field, the Design list contains the
names of the report designs created for the project, in alphabetical