Sorry for such a simple Question .. I am new to AX ,,,
Please tell me the difference between Relation and Join???
Explain in detail please
*This post is locked for comments
Hi,
Please refer the below link:
https://community.dynamics.com/ax/f/33/t/189742
thank u , but I have seen that Link before ..It is so hard to understand .. I dont get it :(
...I cant understand
Normal Relation: enforce referential integrity such as foreign keys. For displaying lookup on the child table.
Field fixed: works as a trigger to verify that a relation is active, if an enum field in the table has a specific value then the relation is active. It works on conditional relations and works on enum type of data.
Ex- Dimension table
Related field fixed: works as a filter on the related table.it only shows records that match the specified value for an enum field on the related table.
InnerJoin: Selects records from the main table that have matching records in the joined table and vice versa. There is one record for each match. Records without related records in the other data source are eliminated from the result.
OuterJoin: Selects records from the main table whether they have matching records in the joined table.
And the other records also shown in the main table.
ExistJoin: Selects a record from the main table for each matching record in the joined table.
The differences between InnerJoin and ExistJoin are as follows:
- When the join type is ExistJoin, the search ends after the first match has been found.
- When the join type is InnerJoin, all matching records are searched for.
NotExistJoin: Select records from the main table that do not have a match in the joined table.
Just look in to these links, you can come to know the differences :)
Joins/Link types :
community.dynamics.com/.../form-data-source-link-types-active-delay-passive-inner-join-outer-join-exist-join-not-exist-join
axhelpdesk.blogspot.in/.../diffrent-type-of-joins-and-linked-type.html
Table Ralations :
amazingax.wordpress.com/.../microsoft-dynamics-ax-2012-understanding-related-field-and-fixed-field-relation-on-ax-tables
msdn.microsoft.com/.../bb190115.aspx
msdn.microsoft.com/.../bb190076.aspx
Thanks
Suresh
All programmers are getting educated (or at least should be) during their studies on Relational databases. You even get one if you try to get the European Computer Drivers' License (ECDL) in school when they show you what an Microsoft Access database is about.
Relations are not different within AX from what you (should) have studied. The only important piece is that AX fields are using building blocks of Extended Data Types (can be linked to a specific table), and Base Enumerations (links cannot be defined). Now if you use such building blocks for your table, AX automatically assumes the relation defined on the EDT, thus you will have a drop-down selection available for the records, if it is the surrogate key, such as EDT SalesId with table SalesTable.
Then again as normal for relational database, you can define the relations on Tables too, where you may even link not just a single field like in case of an EDT, but multiple ones, or associate fixed values for Base Enums.
Joins are the way of linking together multiple tables when you are querying the database, since statements do not care about your relations - unless you use the Query interface.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Tocauer 4
Community Member 2
Nayyar Siddiqi 2
