Quick question:
I'm working on a project that's currently hosted within MS Access and will be ported to MySQL when it goes live.
When a parent record is deleted, are any related child records automatically deleted as well or do these have to be deleted as well (through event code)? Cascading deletes work are working under MS Access, but I'm not sure if it's because of relationships I've set up within the database. So I'm wondering if they'll still work under MySQL.
On a similar note: if a child record contains associated external file information, are those external files deleted when the child record is deleted (assuming that all settings are setup properly).
Thanks! :-)