I have a bound Access database which contains tables "Recipes", "Ingredient s" and "Units". A linked table "Recipe ingredients" holds id references to each of these tables.

My problem occurs when importing a new recipe from a text file. I create the reipe first and call the adapter update for the recipes table and then refill it. Then I create an entry in the recipe_ingredie nts table which I also...