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).
I would not link a master page to a detail page. The reason
it is structured that way is a detail page has to do with that data
table from the master page. If i were you, I would have a master
page, followed by a detail page... followed by another detail