Update Current Form with TempTable?

qngo

My head is hurting on this one. ](*,)
I have a form that refers to an empty table called Account Level Reporting with about 60 fields. On the form there are 2 variables, called DateFilter, and a lookup for Accounts. The table is empty and is to remain empty. I have a Generate Table button, which populates the Temp Table of Account Level Reporting.

What I'm trying to do is update the current form that I'm in with the values generated in the Temp Table. Things work fine when I use FORM.RUN(TempTable), but I'm trying to prevent another form from opening.

<Generate Table> - OnPush()
AccountLevelTemp.DELETEALL;
GenerateTable();

I've tried CurrForm.UPDATE(FALSE) and I've tried changing all the Fields on the tabular form to point to TempTable.FieldName

Any suggestions?

Thanks in Advance

ara3n

Have you tried the new property SourceTableTemporary?

qngo

Sorry forgot to mention, I'm using 4.03

garak

Follow the link and take a look at my posted source code.

viewtopic.php?f=23&t=31360

Regards