First of all, what is a linked table?
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 dataset. This enables you to attach inspections to assets without altering the original data.
Here's how to create a linked table:
Our example is fire hydrant inspections. We will create a new layer for the inspection data and link it to a layer with geometry, in this case, the fire hydrant dataset.
If you want some dummy data, click on the Fire Hydrant data here to download the same data we are using in this tutorial. Then load the Fire Hydrant data to your library. If you forget how, check out Step 1: Add data to your map.
- Click the Forms icon.
- Click the "Create New Form" button.
- Click the "Define A New Form" button. The "Define New Form" dialogue should appear.
- Fill in your form details.
-Add a name ("Hydrant Inspections") and a description.
-Under "Form Type:" choose "Form linked to existing layer".
-Under "Link Layer" choose the "Fire Hydrant" layer because we want our inspections to be linked to our hydrants.
-Under "Linked Field" choose the unique field to link the two layers together.
- 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 inspection form, you can start customizing everything from the icon type and colour to labels and advanced filters for your hydrant inspections layer.