subform table not allowing duplicates

E

Eric

Hi, I have a recipe database in which the main recipe form can call on
another recipe. These details have been saved in a subform Table (ie includes
main recipe ID and the SubRecipe ID. It works well until I try to enter the
same SubRecipe for another main recipe again. I have checked the subTable
fields to allow duplicates but this has no effect. Any help very welcome.
 
B

BruceM

You haven't mentioned the relationship between RecipeID in the two tables.
It needs to be one to many. Is RecipeID Autonumber in the main table and
Number in the subtable, or else the same data type (other than autonumber) in
both? Not sure if this will solve anything, just asking. When you refer to
entering the same sub-recipe for two main recipes, do you have the option of
selecting an existing recipe from a list or creating a new recipe?
 
Top