Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import relationships

Status
Not open for further replies.

NSNewey

Programmer
Jun 29, 2005
125
GB
Hi,

When I import tables from another database, the relationships do not import even though I have ticked the "import relationships" box.

The table I am importing is from a duplicate development copy of a database. When I import ALL the tables that are related, the relationships do import. The problem comes when I add a table, relate it to an existing one then only import the new table because the existing one is already their on both databases.
 
you'd have to import both tables in order to get the relationship.

--------------------
Procrastinate Now!
 
Thanks,

The problem is that I overwrite the data in the existing table.

Is there a way to do this without overwriting?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top