Specifications

86 Using Databases with ID Works Projects
ID Works Basic Version 5 Administrator’s Guide
Connecting to Multiple Tables in a Database
ID Works Basic supports multiple related tables. Multiple tables have
some advantages over a view, the most important being that updates
are less restrictive. The ID Works software derives relationships
between tables by using foreign keys if they are available or by
matching column names if there are no foreign keys. A project can be
connected to up to ten tables.
Always connect Production Form fields to the database parent table
columns first. Connect child table columns after all the parent table
columns are connected. Child table key columns used to relate
records to the parent table do not require a connection. They will be
automatically kept in sync with the parent table by the ID Works
application.
Table rows must be related in a one-to-one relationship if inserts or
deletes are allowed for the project. Updating will work with a one-to-
many relationship if updates are restricted to data in the child tables.
Selection supports a one-to-many relationship.
The Delete All command is not selectable in the Production
application if the project is connected to multiple database tables.