ON DELETE CASCADE in SQL for Access !!!!

[javier]

Anyone knows how make a CREATE TABLE with ON DELETE CASCADE CONSTRAINT in
some of FOREIGN KEY...
In Acces is imposible by SQL, but with MS Access ther is a checkbox that
allow it...How make this?

Thank's

[Michael Yocca]

This is implemented through a delete cascade trigger.
It is important to recognize that the foreign key will fire
before the trigger and prevent the trigger from operating
if it violates referential integrity. So, you will be forced
into using the trigger without the foreign key constraint.
--
Michael Yocca
SQL Server and ERwin Consultant
Ace Database www.acedb.com
Where data quality helps to prevent rework
mi...@acedb.com

javier <mano...@mad.servicom.es> wrote in article
<01bd5bd5$1cce84a0$a107...@manuel.mad.servicom.es>...