Specifications

Connecting Fields 115
ID Works Standard and Enterprise 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 92.
Production
Output
Production
Form
Data
Source