Add Tables
/text/shared/02/14020100.xhp
tables in databases; adding to queries
Add Tables
Specifies the tables to be inserted into the design window. In the Add Tables dialog, select the tables you need for your current task.
When creating a query or a new table presentation, select the corresponding table to which the query or table presentation should refer. When working with relational databases, select the tables between which you want to build relationships.
The inserted tables appear in a separate window in the query design or relational windows, along with a list of the fields contained in the table. You can determine the size and order of this window.
Table
Shows only tables.
Shows only queries.
Table name
Lists the available tables. To insert a table, select one from the list and click Add. You can also double-click the table name, and a window will be displayed containing the table fields at the top of the query design or the relational window.
Add
Inserts the currently selected table.
Close
Closes the Add Tables dialog.