Configure Linked Data Field #

A "Linked Data Field" is when two Entity Types have been configured to be in a database relationship.

For example: There is a many-to-many relationship between Actors and Movies (Actors are in many Movie, and Movies have many Actors in them).

How To Video #

This video shows how to Configure Linked Data Fields. More details follow below on this page.

Video: Link data types together [starts at time 3:10] #

Linked Data Fields #

On the Configure Entity Type page for a specific entity type, there is a section Linked Data Fields that lists all Linked Data Fields for the current Entity Type.

• "Create Linked Data Field" button - click to open the dialog box to create a new linked data field for the entity type.

• "Edit Display" button - click top open the display properties for this Linked Data Field row.

• Configure Relationship button - click to edit the configuration relationship for this Linked Data Field row.

One-to-Many Example: #

This screenshot shows an example one-to-many relationship between Director and Movie. One Director has many Movies, and a Movie has one Director. The entity types are related by the DIRECTOR.ID -> MOVIE.DIRECTOR_ID fields.

Many-to-Many Example: #

This screenshot shows an example many-to-many relationship between Actor and Movie. An Actors has many Movies, and a Movie has many Actors The entity types are related through the join table ACTORS_MOVIES, specifically the ACTORS_MOVIES.ACTOR_ID field and the ACTORS_MOVIES.MOVIE_ID field.