Re: Relations

Hi All,

I want to know about exact reason for creating Relation between two tables and also want to know about the EDT self Relations.

If any one know about the correct reason.

Please tell me

Regards,

Smiley

Hello Smiley,

The foundation of Microsoft Dynamics AX is the relational database. This relational model is represented in the Microsoft Dynamics AX development environment. This means that relationships can be created between tables that contain related data. In Microsoft Dynamics AX, the relationship between tables is called a relation.

The Relations in Microsoft Dynamics AX:

Keep the database consistent (enforce referential integrity).

Are used by the Auto Join system in forms.

Enable the look up of values in other tables (through lookup list/selection list boxes and the Go to the Main Table Form command).

Are used to validate data.

Automatically propagate changes from one table to another.

Auto-define table relationships in queries.

Table relations are most commonly used in form fields to enable the look up of information in another table. If a table relation exists, the lookup button can be used to display a lookup list of values for a particular field.

Hello Smiley,

The foundation of Microsoft Dynamics AX is the relational database. This relational model is represented in the Microsoft Dynamics AX development environment. This means that relationships can be created between tables that contain related data. In Microsoft Dynamics AX, the relationship between tables is called a relation.

The Relations in Microsoft Dynamics AX:

Keep the database consistent (enforce referential integrity).

Are used by the Auto Join system in forms.

Enable the look up of values in other tables (through lookup list/selection list boxes and the Go to the Main Table Form command).

Are used to validate data.

Automatically propagate changes from one table to another.

Auto-define table relationships in queries.

Table relations are most commonly used in form fields to enable the look up of information in another table. If a table relation exists, the lookup button can be used to display a lookup list of values for a particular field.

The Self Relation: If a table has a key, the key must be defined by using relations. Such a relation is called the ‘self relation’.

The self relation should not be set up in situations where the fields in the key are all foreign keys (such as relations to other tables) - or more specifically, where the last field in the self relation is a foreign key.