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 getting populated. The rest of the columns are being populated. I have rebuilt the indexes and foreign keys and this problem still occurs. Is there anything that I could be doing wrong? All tables have time stamps, the primary key is auto-numbered integer and the foreign key is an integer. Thanks, SM
