Use Temporary Table in AX 2009
Temporary table(Table whose property temporary set to "yes") is not persistent media , so at run-time you have to populate the temporary table and attach the same to the form/report. For illustration purpose ,I am using inventTable data and attaching the items whose group is Parts. Steps 1. Create temporary table as TmpTestTable with 3 fields(ItemId,Itemname,ItemGroup). 2. Create a form as TempTestTable and attach the table as datasource 3. Create a new method on the form and copy the following code TmpTestTable populateRecords(ItemGroupId _itemGroupId) { TmpTestTable tmpTable; InventTable inventTable; ; while select inventTable where inventTable.ItemGroupId == _itemGroupId { tmpTable.Itemid = inventTable.ItemId; tmpTable.ItemName = inventTable.ItemName; tmpTable.Itemgroup = inventTable.ItemGroupId; tmpTable.insert(); } return tmpTable; } 4. Call the above method in init() after super as below public void init() { super(); // Call the setTmpData method to attach rec...