Both tables have defined primary keys using autonumbers.
Followed the link in your signature cjard. i went through the code for 'Walkthrough: Saving Data to a Database (Multiple Tables)' making appropriate changes for my code. Still the same problem. Interestingly enough at the bottom of this walkthrough, someone has posted ...
Quote:
|
Adding a customer and order at the same time is giving me an error. A message pops up that complains about a foreign key constraint. This occurs even though the code above has the customer changes taking place before adding orders.
|
Unfortunately still no solution though??