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
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
Thanks Chaitanya
Hi,
Yes, as I mentioned earlier it defines the cardinality in-perspective of header table.
Thanks Chaitanya,
RelatedTableCardinality having 2 options "ExactlyOne" OR "ZeroOne".
The definition of both are same and just applicable for Header Table instead of Line Table.
It's depends on Table design.
Is't correct ?
Thanks!
Arpan
Hi,
Its a part of best practice to always mention RelatedTableCardinality on a relation. Yes, it defines the relation type in-perspective of header table.
Thanks Chaitanya,
RelatedTableCardinality is mandatory to mentioned ?
Here RelatedTableCardinality is referred HeaderTable ?
Please give me more shed on this.
Thanks!
Arpan
Hi,
Yes. Correct.
Thanks Chaitanya,
If the design of table (Line) is mandatory to have more than 1 records then it should be OneMore OR always 1 record then it should be "ExactlyOne" else (Optional) ZeroMore.
Thanks!
Arpan
Hi,
No. As per design of SalesTable and SalesLine, we can have header(record) without any lines.
Sorry Chaitanya,
I wrote wrong ZeroOne intead of ZeroMore.
It should be OneMore right?
Please give me more shed on this.
Thanks!
Arpan
.Hi,
I think you might be checking property RelatedTableCardinality instead of Cardinality.Refer screen shot below.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156