cascading delete

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: jlute@xxxxxxxxxxxx
Date: Mon, 25 Feb 2008 07:54:35 -0800 (PST)

I have tables that are deleting "backwards". For example tblA is the
parent of tblB and tblB is the parent of tblC. When I delete a record
from tblC (through its form which is a subform) it cascades back and
deletes the parent record in tblA. I've never encountered this before.
Can anyone explain? Maybe I'm having a brain cramp but aren't records
supposed to cascade "forward" only?
.

Follow-Ups:
- RE: cascading delete
  - From: Jerry Whittle

Prev by Date: Re: Primary Key & Data Entry Forms
Next by Date: RE: cascading delete
Previous by thread: Re: Access Autonumber NOT Unique
Next by thread: RE: cascading delete
Index(es):
- Date
- Thread

Relevant Pages

Re: Joining 3 tables w/referential integrity
... tblB has a PK field "Config" that I wish to join to the Foreign key ... "Config" field in tblC with referential integrity enforced, ... If tblC is related to tblA, ...
(microsoft.public.access.tablesdbdesign)
Lookup 2 based upon Lookup 1
... TblB ... such that the only values that show in the list are those values from TblC ... In other words, in TblA, you choose a Product Type, and the list of Products ...
(microsoft.public.access.tablesdbdesign)