View, Generate Relations

NF Tools uses Entity Relationship to implement relational database concepts.
In a RDBMS, relationships between tables are implemented with help of primary and foreign keys.
Similarly, in NF Tools, relationships are implemented by means of entity field properties.
User will have the ability to view all the generated entity relationships.
The views are generated in the form of parent-child relation which helps users in understanding the relations more easily.

Using the proper KEYS, user can generate relation between tables i.e. one to one relation / one to many relation

Steps to be followed for creating relation between tables:-

Set the proper keys in the table.
Set the Root Table Name for the Key field.
The fields on which relation is generated should have same name in both the tables.

All the generated relations can be viewed from this page.

In this article

Relations

Relation Name It will show the automatically generated relation names for that selected Entity.
Parent Entity Name Will display the parent’s entity name for that relation.
Parent Table Name Will display the parent’s entity table name for that relation.
Child Entity Name Will display the child entity name for that relation.
Child Table Name Will display the child entity table name for that relation.
Hierarchy Instance Will show the hierarchy instance.
Relation Expression Will display the full parent – child relation expressions.

Entity Name Name of the Entity. It should be unique for that module (database).