Hi,

Access 2002.

I import tables from another database where I only copy the definition
and not the data.

I select the Import Relationships option on the import dialog. After I
do the import the empty tables are there with the correct defintion
and the MSysRelationships table is updated with the relationships
between the imported tables.

However, when I go to Tools / Relationships it only shows the
relationships between tables which were there before the import. Is
this a bug? How do I get the Tools / Relationships window to show the
real information?

Right click in the relationships window and select "show all."

Chris
Microsoft MVP


John Google wrote:
>Hi,
>
>However, when I go to Tools / Relationships it only shows the
>relationships between tables which were there before the import. Is
>this a bug? How do I get the Tools / Relationships window to show the
>real information?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200804/1

On 17 Apr, 20:09, "Chris O'C via AccessMonster.com" <u29189 [at] uwe>
wrote:
> Right click in the relationships window and select "show all."
>
> Chris
> Microsoft MVP
>

Excellent!

Thanks Chris.