Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Error: Cardinality not specified is not allowed

(0) ShareShare
ReportReport
Posted on by 1,550

 [AxDataEntityViewProjectInvoiceEntity/Metadata/ProjInvoiceOnAcc/DataSources/ProjInvoiceJour/DataSources/TaxTrans/Relations/QueryDataSourceRelation1/Cardinality]:NotSpecified is not allowed; the only allowed values are ExactlyOne, OneMore, ZeroMore or ZeroOne for the data source ProjInvoiceJour table TaxTrans relation ProjInvoiceJour cardinality.. 

This is the entity(everything is inner joined). The reason i joined with TaxTrans is because i want to get the TaxCode

The standard relation cardinality between projinvoicejour and taxTrans is not specified

So what should I do

 

1157.image-_2800_6_2900_.png

  • junior AX Profile Picture
    junior AX 1,550 on at
    RE: Error: Cardinality not specified is not allowed

    Hi bharani,

    But this is a standard relation so I'm not sure what I should do with it

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: Error: Cardinality not specified is not allowed

    If you have tableA and VendTable and for tableA you are attaching VendTable with some relation called Vendaccount and AccountNum, then you need to give cardinality and related cardinality right.

    So if tableA can have 10 vendors with same I'd like Vend1 and in VendTable we have one Vend1. Now that means 1 Vend1 in VendTable can have 10vendors in tableA right? Similarly from tableA for 10 vendors 1 vendor is there in VendTable right?

    Assume like a mapping. So cardinality for tableA is zeromore or onemore. OneMore when atleast one related record should be present in this table A for the VendTable. And at VendTable means related cardinality would be exactly one. Means atleast one record should be there related to tableA.

    So if you understood this, based on the tables there add the cardinality for that relation.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans