On Tuesday 26 August 2003 15:06, Andreas Fromm wrote:
>
> When I delete a record of the table realtions I also want to delete the
> record on the data-tables if there is no other record referencing them.
> How can I do this?
You want to add "ON DELETE CASCADE" to the REFERENCES... clause.
See the SQL reference for full syntax details.
--
Richard Huxton
Archonet Ltd