The following section describes how to design a Form with a Subform which allows you to add more flexibility to your Form. Subforms are included in a parent Form so in order to design a Form with a Subform you follow the steps of designing a Form.
If you want to collect data on a repetitive basis, you can add a Subform field and define the frequency using a Date, Month or Week field. You can make that field a Key field for the Subform so as to alert users for duplicate entries for that specific time period for example.
By making that field a Key field you can also add a Lock to the Subform.
How to design a Form with a Subform
- To start designing you Form you first need to add a Database.
- Click on "Add Form" to open the Form Design page.
- In the Form Design page give a name to your Form and click on "Add a field" to view the Field palette.
- Click on "Add field" and click on "Subform" to add a Subform to the Form.
Fill in the Properties of the Subform field by providing:
- Label: type the name for the Subform
- Description: optionally provide a description
- Code: optionally provide a code
In the Settings check the boxes you want to apply for the field.
- Click on "Done" to add the Subform.
- The Subform has been added. Click on it to open the Properties tab and click on "Open Subform" to start adding fields to the Subform.
Make sure that the fields added to a Required Subform can be filled in during data entry. For example, a Subform that consists only of Fields with Relevance rules or the 'Hide from entry' property checked might prevent a user from saving a record altogether.
- You can design the Subform in the same way you would design a Form. Click on "Add a field" to start adding fields define the fields properties to make the Subform even more flexible.
- Click on "Save" on the Form Design page to save the changes.
If you want to collect data on a repetitive basis, you can add a Subform field and define the frequency using a Date, Week , Fortnight, or Month field as a Key in the Subform. You can make that field a Key field for the Subform so as to alert users of duplicate entries for that specific time period or to be able to add a Lock to the Subform.
- Users will be able to add Records to the Subform.