Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You may wish to use the field information in one Datasource to link to another Datasource to retrieve information; we call this “piggy backing”. Following are a couple of scenarios detailing how this may be used.

Piggy Back ScenariosImage RemovedImage Added

Other examples may be to use the UPRN of a property, find the Ward area that it is in and then link that to Census data or Election results. Once you know the street where the property resides you may wish to find out details about the street using the USRN and accessing data such as Parking Restrictions for example.

...

First you need to select the Datasource, from your list of existing Datasources that you wish to use for your entry level Datasource. With this entry highlighted select the Add Cross Reference entry from the context menu.

add_cross_referenceImage RemovedImage Added

You will see a dialog similar to the following:

add_cross_reference_detailsImage RemovedImage Added

Select the Datasource Name to which you wish to cross reference and the Unique Field that you wish to use from the current Datasource that you wish to link to the Unique ID of the cross referenced Datasource.

Click OK to add the new cross reference.

Display Cross ReferenceImage RemovedImage Added

When you select a cross referenced Datasource you will see the Linked to entry at the top right hand side of the dialog. If you wish to change the entry simply select a different field from the list provided.

...