You are here:
< Back

In a relational database environment related Data Items will be spread across multiple physical tables. By defining the Relationships between tables here you eliminate the need for the person designing reports to understand these Relationships. The designer simply selects fields. Foxfire! knows how to connect the tables to retrieve the requested Data Items.

Relationship Editor

Join Tree for Preference: Displays a tree view of the defined Relationships for the current Report Set.

Find: Opens the Relationship Finder, a graphical display of the files to allow you to visually define Relationships between files. This tool should only be used for defining new Relationships, it does not provide an effective view of existing Relationships.

View: Specifies the active view. This field will only be available if you have defined one or more views in the Data Item Editor Advanced Options.

File Info

Parent: Specifies the parent file in a Relationship. In a one-to-many Relationship, the Parent is the file on the one side.

Alias: The alias of the Parent table.
Description: A description of the Parent table.
File Name: The file name of the Parent table.

Note: It is quite common for the Alias, Description and File Name to all be the same name for the Parent file.

Reverse: Reverse the Parent and Child files. Parent becomes Child and Child becomes Parent.

Child: Specifies the child file in a Relationship. In a one-to-many Relationship, the Child is the file on they many side.

Alias: The alias of the Child table.
Description: A description of the Child table.
File Name: The file name of the Child table.

Note: It is quite common for the Alias, Description and File Name to all be the same name for the Child file.

Relationship Parameters:

Join Type: Specifies Inner Join, Left Outer, Right Outer or Full Join.
Weight: Specifies the relative priority between overlapping Relationships. This weighting is used to select a Relationship to use when there is more than one Relationship defined that relates two fields.
Advanced: Opens the Advanced Join Options screen.
Relationship Expression: Defines the Relationship between the Parent and Child file. This should be in the form ParentFile.FIeldName = ChildFile.FieldName.

See also

Relationship Finder | Advanced Join Options

Last Updated: 06/21/15