Advanced Techniques - Many-to-many relationships
This workshop shows you how to create a many-to-many relationship using
references. An order can contain any number of article items.
The example application for this workshop can be downloaded
portal as usual.
The application contains three data groups: "Articles", "Orders" and the
child data group
Each of these contains an edit page where the corresponding data can be entered.
This is the "Create article" page in the browser. Articles that have already
been defined are listed in the view table beneath the edit fields.
Orders can be entered on the "Create order" page.
You can view all existing orders on the "Orders" page. Click on
"Select data set"
to open an order.
Click on "Add order item" to add any number of order items to an order, thus creating
a many(order)-to-many(order item) relationship.
This relationship is easily created via a
which is created in the
properties of the "Order items" data group
and integrates the data fields
from the "Items" data group.
On the "Create order item" page, a drop-down list
takes it values from the referenced data fields. The
is made up of the article number and article name.
This is the "Create order item" page in the browser. Click
for more information about references.