0 Replies Latest reply on Apr 23, 2013 12:07 PM by PatrickLock

    ESS cascade delete from external mysql table

    PatrickLock

      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?