Update Current Form with TempTable?
qngo
Member Posts: 58
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
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
0
Comments
-
Have you tried the new property SourceTableTemporary?0
-
Sorry forgot to mention, I'm using 4.030
-
Do you make it right, it works too!0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
