David, What my intentions are, is that when the User creates a "Recipe" that I will write the record of that recipe to the database under the "Recipe" table. The [Recipe].[MealPlan] varable will tell me when loading the Recipe Meal Plan for viewing a User plan for a Meal(ie, Special Occassion Meal= Birthday Party, Wedding, etc. (see uploaded new "CookIt.mdb" db) There is a Funtion in my program where the User selects ingredients and recipes they will use in developing a "Meal Plan" for a "Special Occassion Meal Plan". All Ingredients, upon User selections, are linked by the "MealPlanName", so that when the User selects a "MealPlan" from a list control that "MealPlan" is loaded. This works fine with my ".xml" database; I was trying to do the same thing with the MS Access DB. How would you go forth in accomplishing this with a MS Access DB? I redid the CRecordset (dsn) to only include the "Recipe" table. It doesn't give any erros, it goes through the AddNew() and then at UpDate() it clears the fields and no record is written to the db.
A C++ programming language novice, but striving to learn