Come join us on November 27-29, 2018 at the Gartner Application Strategies & Solutions Summit 2018 in Las Vegas, USA.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

In this article, we will discuss how to design a many to many form/record relationship based on the sample app.

...

The app is created using simple select box and form grid. You may study its design by downloading the sample app below.

The figure below shows the design of Form1.

Image Added

Based on the figure below, we can see that Form 1 has:-

  1. An ID Generator Field to create a running number as record ID.
  2. Text Field
  3. Form Grid to select items from Form 2 to be stored in the joiner table.

Image Added

Form 2 has identical form design as per Form 1, as explained below.

In the joiner form, it contains just 2 select boxes.

Image Added

Each of the select boxes would point to Form 1 and Form 2 using Default Form Options binder as shown in the form structure figure below.

Image Added

You may try it out yourself by downloading the sample app below.

View file
nameAPP_Many2Many-1-20180507154857.jwa
height250