Dear All,
Can you please let me know how "Cardinality" relation is work in table.
Please give me an example.
Please give me more shed on this.
Thanks!
Arpan
*This post is locked for comments
Hi,
Hope the below link would help you.
https://community.dynamics.com/ax/b/axfaqblog/archive/2016/08/16/understanding-the-tables-cardinality-concept
Cardinallity Description:
The number of times that each primary key value from the referenced table must occur in the foreign key column of the present table.For example, the value OneMore means one or more, but not zero. It means that every parent key value must occur in the child table’s foreign key column at least one time. A relation node under a SalesLine table could use the OneMore value when the business rule requires that every record in the parent SalesTable table relate to at least one item that is being sold.In Microsoft Dynamics AX 2012 this property is not yet used by the system. Future releases of the product can potentially use this property, and the RelatedTableCardinality property.
Hi Arpan,
Kindly mark as "Verified" if you get a solution to close the thread.
If you didn't get required answer, please post the your query in detail so that other experts in the group would provide you help.
Thanks,
N.Sridhar
Thanks Sridhar,
i also go through the link and little bit understand.
Can you please give me an example of each Cardinality based on
ZeroOne,
ExactlyOne,
ZeroMore,
OneMore
You have a plenty of examples in the standard application, simply search for the particular property value you're interested in.
I serached with particular value but not understand.
Can you please any one give me an example for :
means if i set value ZeroOne then what will happened etc...?
Can you please any one help me on this.
I could see lot of explanation provided by others, for your brevity explaining again. Cardinality is the property which explains about nature of the relationship between two tables on the related table.
For example:
ZeroOne: You will select this, provided child Table/related table can either have no record or have only one related record (Fetch Mode is 1:1).
ExactlyOne: You will select this, provided child Table/related table can have only one related record (Fetch Mode is 1:1).
ZeroMore: You will select this, provided child Table/related table can either have no record or more than one related record (Fetch Mode is 1:n).
OneMore: You will select this, provided child Table/related table can have more than one related record (Fetch Mode is 1:n).
Can you provide details about your business requirement such that we can help you better.
Hi Chaitanya,
I have 2 Tables :
Header Table : CrateHeadertable
Fields : CrateID, Name
Line Table : CrateLineTable
Fields : CrateID, Qty, Price
Relation : CrateLineTable.CrateId == CrateHeaderTable.CrateId
Note : Cardinality should be OneMore because it's 1:n relation
Is't correct?
I would recommend to go for ZeroMore, if your CrateHeaderTable can have record without line(Check relation salesTable on table SalesLine) or else its OneMore(as pointed by you).
Thanks Chaitanya,
if your CrateHeaderTable can have record without line means ??
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.
Community Member 4
Nayyar Siddiqi 2
NNaumenko 2
