Subform Filter Problem
IrishGiri
Member Posts: 61
I have a subform that contains a column/field which shows a price. I have created a button which allows the user 2 options: Show all, Show lowest price. The menu button works fine for the Show lowest price - by pressing this the form filters all the records in the form and only displays the record with the lowest price.
My problem then is how to return to the original list of records. This should correspond to the filter, I have set in the SubFormLink. Can I use FILTERGROUP for this?? The user should be able to press the Show all button to return to the previous view of the records i.e. the view of SubFormLink.
Thanks for your help!
My problem then is how to return to the original list of records. This should correspond to the filter, I have set in the SubFormLink. Can I use FILTERGROUP for this?? The user should be able to press the Show all button to return to the previous view of the records i.e. the view of SubFormLink.
Thanks for your help!
0
Comments
-
You can save the filters through GETVIEW and restore them by SETVIEW.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
