ACC1x: Cannot Create Relationships with Attached Tables

ID: Q98228


The information in this article applies to:


SUMMARY

You cannot create a relationship between a Microsoft Access table and an attached table. Relationships can be created only between Microsoft Access tables. Any joins involving attached tables must be created using the query grid.


MORE INFORMATION

To establish a relationship between Microsoft Access tables, do the following:

  1. Open a Microsoft Access database. By default, the Database window has the focus.


  2. From the Edit menu, choose Relationships.


  3. Select a table from the Primary Table list box. Note that no attached tables appear on the list.



REFERENCES

For more information, search for "relationships between tables", then "Defining Relationships Between Tables" using the Microsoft Access Help menu.

Additional query words: Tables ISAM


Keywords          : kbusage TblOthr 
Version           : 1.0 1.1
Platform          : WINDOWS 
Issue type        : kbinfo 

Last Reviewed: March 23, 1999