FormVar.RUNMODAL Shows all Records, not the Filtered Set

r44712
Member Posts: 40
Hi all,
I am working on a solution that will let a user choose an alternative product if the one they are trying to order is not available.
If I use FORM.RUN(72379,TmpRecords) it shows the correct filtered set, however if I use MappedProductsForm.RUNMODAL(TmpRecords), it shows all rows in the table (which is wrong).
I need to use the latter method, so I can set a caption on the Form that describes why they are being prompted to choose an alternative.
Many thanks in advance.
I am working on a solution that will let a user choose an alternative product if the one they are trying to order is not available.
If I use FORM.RUN(72379,TmpRecords) it shows the correct filtered set, however if I use MappedProductsForm.RUNMODAL(TmpRecords), it shows all rows in the table (which is wrong).
I need to use the latter method, so I can set a caption on the Form that describes why they are being prompted to choose an alternative.
Many thanks in advance.
0
Comments
-
Use
MappedProductsForm.SETTABLEVIEW(TmpRecords);
to set the filters on the form...0 -
Sorry, forgot to add, I've already added:
MappedProductsForm.SETTABLEVIEW(TmpRecords)
andMappedProductsForm.SETRECORD(TmpRecords)
The table is also temporary as its created on the fly, based on a number of paramters and to exclude duplicates, etc.
Cheers!0 -
If you are using NAV 5.0, use the SourceIsTemporary property on the form. Do not forget that temporary tables are workng in another way than common tables and in some situations you need to "copy" the records into rec one by one.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions