AnsweredAssumed Answered

ESS cascade delete from external mysql table

Question asked by PatrickLock on Apr 23, 2013

Title

ESS cascade delete from external mysql table

Post

      

     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?
      

Outcomes