Hello Everyone, I am relatively new to Axapta, and I have a quick question. Is it possible to build a lookup based on a temporary table, and if so, how? While I am able to build lookups from permanent tables, using extended data types and the systablelookup class, as well as displaying information from a temporary table in a grid, I don’t seem to be able to combine the methods. Any suggestions, tips, advice, or code/examples would be greatly appreciated. Regards Barry.
all i know is temporary tables is just like a bridge to transform data to another table then do deleting them from that tmp table, so you dont have any data in tmp tables.
If the form which have the Tmp datasource, you can get the values enetered by the user in that Tmp datasource before the form is closed by declaring a container.
TmpTabel tmpTable; //declaring the TmpTable;
int i = 1,j=1;
Container cntTmp;
;
TmpTable_ds.first(); //the form TmpTable data source
do
{
cntTmp = conpoke(cntTmp, i, TmpTable);
i++;
}
while(TmpTable_ds.Next());
Now you have all the data enetered to the TmpTable form inside the cntTmp container
To see the values entered, do:
for(j;j<=conlen(cntTmp);j++)
{
TmpTable = conpeek(cntTmp,j);
info(TmpTable.RecId); //info the RecId for each record enetered or any value you want
}