Re: Foreign Key problems

2004-05-18 Thread Daniel Kasak
Sonj McCoy wrote: Hello Everyone, I am having problems with foreign keys in MySQL InnoDB type databases. For some reason, when adding a new record within an MS Access subform (based on a query of two tables (parent table and child table), the corresponding foreign key column in the child table not

Re: Foreign Key Problems

2004-02-20 Thread Victoria Reznichenko
"Scott Purcell" <[EMAIL PROTECTED]> wrote: > > I am trying to create some tables that I can use the delete on cascade = > function for. This would help me code the project and ensure data = > integrity. I am on the docs @ = > http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html but I am