Tips & Tricks - M-to-N relationships

This article shows you how references can be used to create an m-to-n relationship. An order can contain any number of article items.

You can download the sample application here and then import it as usual.

Application structure

The application consists of the data groups "Articles", "Orders" and the subordinate data group "Items", in which data can be entered on the respective input page.

Here you can see the "Enter article" input page in the browser view. Articles that have already been defined are listed in the view table beneath the edit fields.

Orders can be entered on the "Enter order" page.

Existing orders can be found on the "Orders" page. Click on "Select data record" to open the order.

By clicking on "Enter item", you can create any number of items per order and thus create an M(order)-to-N(article) relationship.

This relationship is simply created by a reference that is created in the properties of the "Item" data group and integrates the data fields of the "Article" data group.

On the "Enter position" input page, a selection list takes the values from the referenced data fields. The display value is made up of the article number and article text.

Here you can see the "Enter position" input page in the browser. You can find more information on the subject of "References" here.