I have 2 tables, orders and recipes. An Order can have multiple
recipes. I can't figure out how to use the wizard to create a CRUD
application that will link the 2 tables together.
For my last attempt I created a master and detail page for Orders
and a master and detail page for recipes.
The docs say you can link a Master page to a detail page but that
doesn't seem to be the case, the Wizard won't let you. But I can
link the Recipe Master to the Orders Master (by drag and drop). Like
this:
Orders Master
| |
| orders detail
|
Recipe master
|
recipe detail
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?
Thanks
