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
- 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