Populate grid in a form from temp table

Finance and Operations/AX Developer Forum
1

Hi all,

how I can populate a grid in a form from a temp table?

I have in data source the table, and i ha set the data source on the grid, but I can’t see any field.

Thank you

2

Hi Alessandro,

Let me tell you that tmp table doesn’t have data to send it to some other table, It would get the data dynamically.

And regarding design part of form, As soon as you add the datasource in form it will never populate the field in form design automatically, rather you have to do it manually from datasource.

3

Thank you so much for your answer.

I’m a new entry, so can you tell me how I can show the data manually?

4

Hi,

The following link might help you http://www.axaptapedia.com/Temporary_tables

regards,

Thomas

5

I solved it.

TmpTable tmpTable;

tmpTable.filed1 = …

…

tmpTable.filed6 = …

tmpTable.insert();

formDataSourcesTmpTable.setTmpData(tmpTable);

and the form grid show automatically the data