# How to Attach Multiple Photos to Features

TIP

To see this setup in practice, clone the following project: Mergin Maps Project documentation/forms_multiple_photos documentation/forms_multiple_photos (opens new window).

To link multiple photos to a single feature, we need a unique field to link following tables:

DANGER

Do not use the FID field to link these tables. FIDs can be changed during synchronisation, which can result in having photos linked to the incorrect feature. You can learn more about synchronisation in Behind Data Synchronisation.

To set 1:N relation between these tables correctly:

  1. Create a new text field in the survey layer, here: unique-id
    uuid
  2. Use the uuid() as the default value for this field in Layer Properties. This function assigns a unique identifier to every created feature, even when different surveyors create features simultaneously.
    uuid
  3. Create a new text field in the non-spatial table (here: photos) that will be used to store the UUID of features from the survey layer (the foreign key), here: external-pk.

Now we need to configure a 1-N relation:
4. From the main menu, select Project > Properties ...
5. In the Relations tab, select Add Relation
relations

  1. Define the parent and child layer and the fields to link these layers. Here:

    • Name is the name of the relation, can be left blank
    • Referenced (parent) is the spatial layer Survey
    • Field 1 of the Referenced (parent) is the field unique-id that contains the UUID
    • Referencing (child) is the non-spatial layer photos
    • Field 1 of the Referencing (child) layer is the external-pk that contains the foreign key to link photos with surveyed features.
      photos relation
  2. Navigate to the Attributes Form tab in the Properties of the photos layer. Set the Widget Type of the foreign key external-pk to Relation Reference:
    form

Mergin Maps Input detects the type of 1-N relation and displays the image viewer for the relations.

Many photos to a single feature