Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Thursday, June 27, 2013

Static query creation in Dynamic AX

Hi,

   Static Query:

1.1.Create new query
1.2.Drop parent table in the data source; drop the range – field
1.3.Drop child table in the datasource of parent table; drop the range – field
1.4.Change Relations property to Yes in child table.
1.5.If you expand the Relations node you will find auto populated relation.

Regards,

No comments:

Post a Comment

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...