Well, 3 tables. * You want a Recipe table which would include the method. * An Ingredients table which would list all the possible ingredients * Then another table linking these together: a RecipeIngredients table. It would have three columns: RecipeID, IngredientID, and the quantity of that ingredient.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 30, 2002 9:29 AM Subject: RE: CF/Database Help > have two tables > > a recipe table and an ingredients table with the foreign key relation > between them. > > Anthony Petruzzi > Webmaster > 954-321-4703 > http://www.sheriff.org > > > -----Original Message----- > From: Deborah Curley [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 29, 2002 4:31 PM > To: CF-Talk > Subject: CF/Database Help > > > Hi, > I have a friend whose a chef and has asked me build him a database of > recipes and a web app he can use to search, enter new recipes, etc. What I'm > > trying to figure out is the best way to store the ingredients since a recipe > > can have anywhere from 5 to 20 ingredients? Any ideas on the best way to > handle that? > > TIA, > Deb > > _________________________________________________________________ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
