One DB 2 another (1 Viewer)

[Hann]

When importing a table from an existing DB into a new one the entries which are related to a different table in the original DB are only displayed with their related autonumber.
So how overcome this problem?

In fact I would like most to delete the relationship in the imported table so that only the entries are displayed. Like one would go for "special paste only values" in excell to dismiss rather nervetaking formulas.

If anyone should understand this request an answer would be highly appreciated.

Hann

 

[Pat Hartman]

You can also import the related table. Then use a query to join the two tables to obtain the information in a single recordset. Alternatively, you can create a query that joins the two tables in the "from" database and then import the query.