[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
Hi bharani,
But this is a standard relation so I'm not sure what I should do with it
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.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156