Filter to last 6 records
paul_newns
Member Posts: 6
Hi,
I'm trying to use onnextrecord to filter the records displayed to the last 6 occuring, but i am having issues with the trigger. One of which is that it keeps asking me if want to rename the record. Can some give me a breakdown of the best way to write this.
Cheers in advance.
I'm trying to use onnextrecord to filter the records displayed to the last 6 occuring, but i am having issues with the trigger. One of which is that it keeps asking me if want to rename the record. Can some give me a breakdown of the best way to write this.
Cheers in advance.
0
Comments
-
Not sure where you are and what you want to achieve, but OnNextRecord in a Form/Page is used to do something if some next record functionality (e.g. Next Arrow in the menu bar) was used. And you have to be very careful with it because if you put code in here then the standard behaviour will be replaced.
Also have a look at NEXT function. Parameter Steps could be used to get the 6th last record, e.g.FINDLAST; NEXT(-6);
"Money is likewise the greatest chance and the greatest scourge of mankind."0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 324 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