ESS cascade delete from external mysql table
I am using ESS to connect an external mysql 'product' table using ODBC. I have a filemaker table with a foreign key relationship 'product_id'. Is it possible to cascade delete the record with the 'product_id' foreign key, when I delete a row in the external mysql 'product' table, from outside filemaker, to keep the filemaker table up to date. This only seems to work if I delete the row from within filemaker. Otherwise, how do I keep filemaker tables up to date when external table rows are deleted?