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

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

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 =
TABLE_2.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,
Joaquim.