RI Doubt

BOMCalcTrans.CalcType==WrkCtrTable.4 && BOMCalcTrans.Resource==WrkCtrTable.WrkCtrId

What does 4 mean in the above line… and is it possible to get all the related values for numbers in relations…

Other Examples:

BOMCalcTrans.CalcType==WrkCtrTable.5 &&
BOMCalcTrans.CalcType==WrkCtrTable.6 &&

Is that X++ code? I don’t think it ever can be compilable, because you’re not allowed to create a field with name equal to “4”.

And what do you mean by “to get all the related values for numbers in relations”?

Hi,

Those are relation between tables… Referential Intergrity…

this is what I expect

CustInvoiceTrans.TaxWithholdItemGroupHeading_TH==TaxWithholdItemGroupHeading_TH.RecId… without numbers

few are like

CustLedgerAccounts.AccountCode==CustTable.0 && CustLedgerAccounts.Num==CustTable.AccountNum

Relations are defined in properties in AOT, so where did you get the code? Can you show us a picture?