Access and mySQL Problem

[Emmanuel Brunacci <brunacci_(at)_steinbeis-europa.de>]

I am new with mySQL and I have the following problem.
My ACCESS databank is linked with mySQL via ODBC. All is working fine
exept:
I have two tables and there is a link or relation infinite/infinite
between theses two tables. Therefore there is a third table between
these two tbale that make these relation possible:

Let say:
first table: Client
ID_client
Client_name

Second Table: Order
ID_Order
Order_name

To do the infinite/infinite relation: I am using the table: detail
ID_Order
ID_ client

All my table are linked via myODBC to mySQL.

Now I am doing a form. In this form there is a main form using the table
Client and a subform using the tables
order and detail. The problem is I can not do a new registration in the
subform. It seems that ID_order in Order don't want to increment. 

Without the link via myODBC to mySQL, it works. What can I do?

---
*** Weitere Infos zur Mailingliste und MySQL unter www.4t2.com/mysql