Overview

PhixFlow can display data from any Table and any Tables that it has relationships with. Relationships between tables are defined on an Entity Relationship Diagram (ERD). For more information on ERD's, see Entity Relationship Diagrams.

This page describes how to utilise these relationships to display data, using a grid as its example. The concepts can be used on all data bound components.

Relational Attributes

An Employees table has a relationship with a Company table. See the below ERD:

Each employee belongs to a company and has a company ID associated to it. It is stored in a foreign key attribute, Company. This attribute is linked to the primary key (id_1) of the Companies table.

The Companies table also has a display name attribute (CompanyName). This is the attribute that is displayed on the front end when adding a foreign key to any data bound component.

For more information on ERD diagrams and relational views, see Entity Relationship Diagrams.

Adding Foreign Key Attributes

When a foreign key, e.g. Company on the table Employees, is added to the grid, PhixFlow does the following automatically:

• adds the display name attribute (CompanyName) from the related table (Companies).
  • This attribute is marked with  in the grid header,
• hides the foreign key.

Adding Relational Attributes from a many:1 Rrelationship 

On the above grid the user also wants to display the companies address on the same grid. This data is stored on the Company table and can be accessed using the relationship. To add the company address

1. Right click on the grid and click Show attributes for 'Employees'
2. Click the Related Table Companies(Company)
3. Drag and drop the attribute Address onto the grid. This attribute is marked with   on the grid header.