Relationship Records
Previous Topic  Next Topic 


Relationship records in Heurist link two Heurist records together, regardless of type. With this simple function, Heurist provides much of the power of many-to-many relationships in a conventional database, with a fraction of the effort.


Heurist relationship records have three very powerful features:


  1. They are implemented as a standard Heurist record type, so they inherit all the characteristics of a Heurist record - they can be edited like any other record, they have a title, data fields, annotation, discussion, tags, ownership, even a geographic location;


  1. They can link ANY two records, whatever their type - no prior knowledge or specialise programming is needed (with relational databases a separate linkage table, and programming, is generally required for every pair of record types to be linked);


  1. They include, by default, fields for relationship type (required) and time period (optional) over which the relationship applies (many real-world relationships have a limited duration).


When editing a Heurist record, there is a special section which allows the creation of relationship records which link the record to other records in the database.


Current relationships are shown as follows:



New relationship records can be added by clicking on the Add a relationship link, selecting the relationship type and searching for another record (target) to which to link the current record (source)



Relationship records are a record type developed to link Heurist records together and identify the type of relationship that links them.


Relationship records are created by editing a Heurist record. 


  1. Select a Heurist record
  2. Click on Relationships on the right-hand panel
  3. Click Add a relationship
  4. Select the type of relationship from the drop-down menu
  5. Click into the Related record field (the Find records window will appear)
  6. Select the record link to (and forge the relationship with) - or - create a new record to link to (the record appears in the Related record field)
  7. Click Save


The required fields for a relationship record are:



Note: future versions of Heurist will provide a graphic relationship editor which will display a record's relationships as an editable network of relationships.


See Also: Relationship Type, Dates and Annotation