[AccessD] Relationships / Indexes

>> If you are renaming and copying/adding tables in the back end then the
relationships will be broken and NOT restored when you rename the new table
so that it uses the original name. <<

Even if the relationships ARE defined in the back end?


Mark


-----Original Message-----
From: Heenan, Lambert [mailto:Lambert.Heenan at aig.com] 
Sent: Monday, May 10, 2004 11:55 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Relationships / Indexes


I just checked, and the answer is... it depends.

If the related tables are in a back-end and you set up the relationships in
the front-end using linked tables, then when you copy/add one table, rename
the original and then rename the copy/additional table so it has the same 
name as the original table, the relationship will be recreated between the
two tables with the original table names. 

This happens whether you work with the table on the one or the many side of
a relationship, as long as you do all the copying/adding and renaming in the
front end.

If you are renaming and copying/adding tables in the back end then the
relationships will be broken and NOT restored when you rename the new table
so that it uses the original name.

Lambert


> -----Original Message-----
> From:	Mitsules, Mark S. (Newport News) [SMTP:Mark.Mitsules at ngc.com]
> Sent:	Monday, May 10, 2004 9:01 AM
> To:	'[AccessD]'
> Subject:	[AccessD] Relationships / Indexes
> 
> Group,
> 
> If I have table with dependent relationships and existing indexes, rename
> it
> (not delete), then add a second table (named as the original table) with
> identical indexes, are the original relationships unaffected?
> 
> 
> Mark
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com