[AccessD] 2 Questions

Stuart,
Agree, just forgot to mention *deletes* besides *inserts* and *updates* ...
Asger
-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Stuart McLachlan
Sendt: 10. marts 2010 02:56
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] 2 Questions

To me, the most importance role of referential integrity is with  "deletes".  Without RE, it is all 
too easy to get "orphaned"  records.  This can lead to all sorts of problems when trying to 
summarise data.

-- 
Stuart


On 10 Mar 2010 at 0:07, Asger Blond wrote:

> But establishing foreign key constrains is a quite different beast. It
> has per se nothing whatsoever to do with joining fields in *queries*:
> it is there for enforcing consistency between values in different
> fields when you are doing *inserts* and *updates*. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com