I need some Microsoft Access / SQL Server 2000 help. I have a SQL
Server 2000 database that is using Access as a front end (adp file).
Since SQL server does not allow cycle cascading, I am having problems.
For example, suppose I have tableA, tableB, tableC, and tableD. tableB
and tableC each have a foreign key (tableAID) which is tableA's
primary key. tableD has 2 foreign keys (tableBID and tableCID), one of
which is tableB's primary key and one is tableC's primary Key. The
problem is that I can not have ON UPDATE/DELETE CASCADE because it is
circular/cyclic referential integrity. (I get an error when I try to
set both tableB and tableC to ON DELETE CASCADE... I can only set it
for one of them) What can I do to still have the behavior of ON
UPDATE/DELETE CASCADE? I think there is a way to do it with triggers
but I don?t know how to program a trigger. My objective is that when I
delete (or update) a row in tableA, the corresponding rows in tableB,
tableC, and tableD will be deleted/updated. Please help! I need an
answer by July 20 approximately 9:00 AM EDT. Thanx!

---

Clarification of Question by jbauer-ga on 19 Jul 2005 18:56 PDT

Is there a way to set the expiration date of the question? Because I
could not find a way to set it. As I said in the question I would like
this to be answered by July 20, 9:00 AM EDT.