Linking a form or report to tables
The Query object links a form or report to a table, making the table’s fields available to the controls on the form or report. One Query object can refer to multiple tables in its SQL statement, or you can use multiple Query objects with an appropriate query statement in each.
If you need to link to table data in an SQL or ODBC database, you must first assign the database a BDE alias in the BDE Administrator. If you haven’t done this yet, see How to connect to an SQL database server. Then, to see your tables listed in the Navigator,
Click the Navigator’s Tables tab.
From the Look In drop-down list, select the alias of the database you want to access. Tables from the selected database appear listed on the Navigator Tables page.
If you are linking to BDE-standard tables, use the Navigator Look In drop-down list to select the directory that contains your tables. (Click the Tables tab to see the tables listed.)
From there, you can link to a table in two ways:
Automatically, by dragging from the Navigator or using a wizard
By dragging data access components from the Component palette to the design surface and setting linking properties