Alfasith AX

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

Thursday, August 13, 2015

Creating a views in AX

Hi,

Create views 

  • Create new view
  • Metadata node, right-click on the Data Sources node and select new data source.
  • Change table property to the table name (parent).
  • In the ds of parent table create another ds and select table property as child table.
  • In the child table ds select yes to relation property.
  • Observe 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...