Relations in AX

1)Normal         2)Fieldfixed       3)Related fieldfixed

Normal:::To specify the relation fields without any conditions…

Fieldfixed:::To specify the relation fields to restrict the records in the” primary table”..[Means first table]

Related Fieldfixed:::To specify the relation fields to restrict the records in the “related table”….[Means Related table]

For Example:

Take two tables…Custtable having Accno,Name,Gender[male,female—- male means0 female means 1]    [primary table]

CustTranse having Accno,Transdate,Amount,Paid  [ yes or no—–yes means 0   no means1]   this is related table [Secondary table]

Normal—–Custtable.Accno==CustTranse.Accno

Fieldfixed—-   Custtable.Gender    == 0

Related Fieldfixed—-   1 == CustTranse .paid

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s