[AccessD] 2 Questions

Stuart McLachlan stuart at lexacorp.com.pg
Tue Mar 9 19:56:01 CST 2010


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*. 




More information about the AccessD mailing list