Specifications

92 Using Databases with ID Works Projects
ID Works Standard and Enterprise Version 5 Administrator’s Guide
You select the OLE DB provider and data source for your project by
clicking the Select button on the Data Source tab of the Edit Project
Properties dialog box. (To access the Edit Project Properties dialog
box, from the menu bar, select File and then Project Properties.)
Clicking the Select button launches the Microsoft Data Link
application, a wizard-like program that changes depending on the
choices you make. Online help is available for the Data Link
application.
See the ID Works ReadMe file for the provider recommended for your
database product.
If you must use the ODBC provider, use the ODBC Data Source
Administrator to create an identically-named data source on each
computer on which your ID Works project will be used. (A System
DSN is recommended.) You access the ODBC Data Source
Administrator through your computer’s Control Panel.
Connecting to Multiple Tables in a Database
ID Works Standard and Enterprise support 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