Adding a Reference field to reference many fields of another Form (cascading effect)

Before adding a Reference field, make sure you have defined as Key fields the fields you want your Form to refer to.

  • Navigate to your Form, and in the Form Design page, click on "Reference" to select it from the Fields palette.

Make sure you have defined as Keys the fields you want your Form to refer to.

  • Search for the Database and the Form that contains the Form and the Records you want to link to. Click on the arrows to reveal the contents of each Database.
  • Select the Form and click on "Continue".

Fill in the Properties of the Reference field by providing:

  • Label: type the question for which the user will select an option
  • 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 field.
  • The Reference field has been added to the Form.
  • When you finish adding fields, click on "Save" to save the Form.

Note that in this example, the referenced fields were:

  • a Reference field (referencing the Provinces available in the Geodatabase)
  • a Text field
  • a Single Selection field

and were ALL defined as Key fields in the referenced Form.

That is why users were able to see the specific options in the dropdown list.

Next item