Find related field in Dynamics AX
- by DAXShekhar
static void findRelatedFieldId(Args _args) { SysDictTable dictTable = new SysDictTable(tablenum(InventTrans)); int i,j; SysDictRelation dictRelation; TableId externId = tablenum(SalesLine); IndexId indexId; ; // Search the explicit relations for (i = 1; i <= dictTable.relationCnt(); ++i) { dictRelation = new SysDictRelation(dictTable.id()); dictRelation.loadNameRelation(dictTable.relation(i)); // If it is a 'relation' then you use externTable(), but for extended data types you use table() (see next block). if (SysDictRelation::externId(dictRelation) == externId) { for (j =1; j <= dictRelation.lines(); j++) { info(strfmt("%1", dictRelation.lineExternTableValue(j))); info(fieldid2name(dictRelation.externTable(),dictRelation.lineExternTableValue(j))); } } } info(strfmt("%1", dictRelation.loadFieldRelation(fieldnum(InventTrans, InventTransId)))); }
