Use Case - Manual table creation + “Many to Many” relation

You create a table with all students who attend music class and what instrument they choose. Users could play one or more instruments, and some users could play the same instrument. So, here’s a "Many to Manyrelationship between users and possible musical instruments.

STEP 1: Create an InForm table

  • From “My IntelliBoard”, go to Apps > InForm.
  • Click “Add Table”.


  • Under Table General Info, enter Table Title as “Music Class”.
  • Choose “Everyone Can Manage an Entry” option from “Entries Managing Mode”.


  • Under Table Columns enter the column name as “Instrument”, and select the type as “Enum (because we may have only some instruments and want them to be shown as a drop-down in our future form). Click “Save” to add the column to the table.mceclip2.png
  • Under Table Relations select ‘Many to Many’ options because we want to be able to assign one music instrument to several users per time. 
  • Relate this to the ‘Users’ table, as we need to assign instruments to students.
  • Select Full Name to show as we should know whom we assign the instrument in future form.
  • Click “Add”.
  • Click “Save”.


STEP 2: Create InForm Form for adding new data.

  • From “My IntelliBoard”, go to Create New > Create InForm.
  • Enter the Form Name as “Music Class Entering Form”.
  • On the right-hand side, choose the “Music Class” table.
  • Drag-and-drop column and relation to the middle block.


  • Click on the “Instrument” column.
  • On the left-hand side, make this “Required”.
  • Add some options that will be shown in a drop-down. For this, enter the option name and click the “+” icon. 
  • From the left side box, click “Save” for saving column options.
  • Click “Save” in the middle block for saving the whole form.


STEP 3: Add Master Form to the table

  • From “My IntelliBoard”, go to Apps > InForm.
  • Find “Music Class” table. Click 3 dots under Actions, and select Edit.
  • Under Table General Info, select “Music Class Entering Form” for the “Master Form” setting. Select Instrument under Name Column.
  • Click “Save” at the very bottom of the page.


STEP 4: Add new and edit entered data

  • From “My IntelliBoard” scroll down to InForm and find “Music Class Entering Form
  • Enter some data by selecting an instrument from the first drop-down, and then choosing user(s) from the second drop-down.
    Note: You could select several users per time for assignation because we have selected “Many to Many” relation.
  • Click “Save” to add a record.


  • In case you wish to add more users to some existing record or remove some records, you could edit the entered data. For this, from “My IntelliBoard”, go to Apps > InForm.
  • Find “Music Class” table. Click on the 3 dots from Actions, and select Show.
  • For the required record, click 3 dots from Actions and select Edit.
  • You will be directed to the form (Master Form you’ve added before) where you could add more users or remove some from those already added.
  • Make changes, and click “Save” for the record.


For additional assistance, please email





Was this article helpful?
0 out of 0 found this helpful