Erika L. Walker-Arnold wrote: > Hmmm.... > > I'd prolly set up the db this way, off the top of my head without > actually taking a lot of time to mull it over ... : > > Recipe > ------ > ID > Name > Instructions > Yield > > RecipeHistory > ------------- > ID > Recipe_ID > Poster_ID > DatePosted > DateUpdated > DateApproved > Approved > > RecipeIngredients > ----------------- > ID > Recipe_ID > Amount > IngredientName
I would make Ingredients a separate table, and RecipeIngredients a table with ID, Recipe_ID, Ingredient_ID and Amount. Jochem ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
