Subject [newbie] Delete related Records?
Author Joaquim Macedo <>
Hi all.

Suppose that I have 2 tables. These are related with a Foreign Key on

If I delete a record on a TABLE_1, I would like that a record(s)
would be deleted also on TABLE_2, where: TABLE_1.FIELD_RELATED =

What is the best approach to do this?
1) Use database triggers,
2) Use the TIB_Query.DeleteSQL property,
3) Define it on the Foreign Key,
4) Another ...?

Thanks a lot in advance.

Best regards,