Setting filters on Primary Key
afrancis
Member Posts: 43
Hi,
Before displaying the records from a table, I want to filter the records based on its primary key "No.".
For this, the required filter was set at the OnInit trigger of the form.
But when we run the form, it displays all the records. Setting filters for the fields other than the primary key works fine.
Am I missing something? Why is the filter set on the primary key not considered when the form is opened?
Regards,
Anse
Before displaying the records from a table, I want to filter the records based on its primary key "No.".
For this, the required filter was set at the OnInit trigger of the form.
But when we run the form, it displays all the records. Setting filters for the fields other than the primary key works fine.
Am I missing something? Why is the filter set on the primary key not considered when the form is opened?
Regards,
Anse
0
Answers
-
I have resolved this issue. There was another filter set on the primary key down the line.
Anse0 -
Well done!
Thank you,
Kok Keong0
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
- 250 Dynamics CRM
- 102 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