1 Reply Latest reply on Apr 13, 2007 2:01 PM by JoeADSK

    how to link 3 tables with CF/Flex application wizard?

    bobk1 Level 1
      I have 3 tables, orders, recipes and ingredients. An Order can have multiple recipes, and a recipe can have mutiple ingredients. I can't figure out how to use the wizard to create a CRUD application that will link the 3 tables together.

      For my last attempt I created a master and detail page for Orders, a master and detail page for recipes and the recipe detail page includes a datagrid for entering ingredients. The problem: how to link the recipe master to the current order .

      The docs say you can link a Master page to a detail page but that doesn't seem to be the case, the Wizard will not let you. But I can link the Recipe Master to the Orders Master (by drag and drop). That creates a 'Recipes' button on the Orders Master which opens the Recipe Master from where you can add a recipe. The problem is that the Recipe detail should be linked to the current order but doesn't appear to be linked to anything (I display the linking Order_id column).

      is this possible or am I doing something wrong?