License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
- Many2Many_table1
- Many2Many_table2
- Many2Many_joiner
where the last table mentioned will act as the junction table.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
In this generic sample app, we are treating "Form 1" as ingredients and "Form 2" as a recipe.
The figure below shows the list of recipes.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
The figure below shows the list of ingredients.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
A recipe requires multiple ingredients and an ingredient is used by multiple recipes. The following figure depicts the "joiner" records.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
And, here's how the joiner table records look like. Observe c_id_form1 and c_id_form2. They are the foreign key to table1 and table2 respectively.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
This is table1 data.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
This is table2 data.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
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.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Based on the figure below, we can see that Form 1 has:-
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
An ID Generator Field to create a running number as record ID.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Text Field
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Form Grid to select items from Form 2 to be stored in the joiner table.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Form 2 has identical form design as per Form 1, as explained below.
In the joiner form, it contains just 2 select boxes.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
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.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
You may try it out yourself by downloading the sample app below.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Related Documentation
Builder Advanced Tools#ERD
APP_Many2Many-1-20180507154857.jwa
