A linked table contains tabular data that has no geometry, but is instead associated, or linked, to a layer with geometry. One use case for linked tables is inspections and maintenance on assets. For example, you can create a linked table for your inspections data and attach it to a unique ID for each individual asset in a data set. This enables you to attach inspections to assets without altering the original data.
Creating a Linked Form/Table:
- Click the Forms icon.
- Click the "Create New Form" button.
- Click the "Define a New Form" button. The "Define New Form" dialogue should appear.
- Add a name and a description.
- Under "Form Type:" choose "Form linked to existing layer".
- Under "Link Layer" choose the data source that you'd like to have linked. (i.e. Choose a Hydrant layer, if you are creating a hydrant inspection form).
- Under "Linked Field" choose the unique field to link the two layers together.
- Click "Save".
- The form will open in edit mode. Click the 'New Question' button to start adding some fields.
- When you have added all of the fields/questions you need. Click "DONE" in the top-left corner of the form edit screen.
Now that you've set up your linked form, you can start customizing everything from the icon type and colour to labels and advanced filters.