MySQL with MS Access Front End

Question

Hi,

I am migrating the linked data tables form MS Access to a MySQL Server. The linked tables are working fine, I have all the necessary read/write privileges.
I can add record to tables without any problems. But when I use a form with a subform to enter data the two separate tables refuse to update.
In the old configuration form has a primary key and field for data to be entered. When I moved to the subform in a second table a record would be created with its own primary key (autoincrement), a reference to the primary key of the main table and field for entering data in the second table.

If I try to to that with the linked table on the data server ODBC throughs an error.

What is going wrong, what do I do wrong?

Thanks for any suggestions, boz