Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Recipe confusion

    I'm working on a very simple recipe database, but it has a slight complication... recipes can in turn be ingredients. For example, a turkey sandwich recipe could contain a mayo recipe, a bread recipe, etc. I just can't figure out how to plan it right... any suggestions?

  2. #2
    Join Date
    Aug 2004
    Posts
    330
    Try looking at this post. http://www.dbforums.com/t1201563.html In your case, leave out the bag table and include a recursive relationship on the recipe table. The recursive relationship will allow you to make a recipe able to contain many recipes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •