Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 302 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Filtering a Fast Lookup
ANavUser
Member Posts: 1
Hey there,
I'm relatively new to NAV (since beginning of August 1st). My question is, whether it is possible to filter in a Fast Lookup. The idea is as follows:
- The user enters a resource number in the corresponding field. (Table relation to table "Resource")
- In a second field, the entries shown in the Fast Lookup shall be filtered by the previously entered resource number.
1. Is this possible in NAV?
2. How can I accomplish this behavior?
I'd like to try it for myself, so hints are enough... for the beginning
I'm relatively new to NAV (since beginning of August 1st). My question is, whether it is possible to filter in a Fast Lookup. The idea is as follows:
- The user enters a resource number in the corresponding field. (Table relation to table "Resource")
- In a second field, the entries shown in the Fast Lookup shall be filtered by the previously entered resource number.
1. Is this possible in NAV?
2. How can I accomplish this behavior?
I'd like to try it for myself, so hints are enough... for the beginning
0
Answers
In his case you need to use the table relation property of that second field to set the filter.
This property is available in the table field as well as on the page control. Use the table property if the relation needs to be enforced. If you want to implement this as just an editing aid, use the page control.
Also you might want to not filter the lookup if no resource number has been entered. In this case use conditions in the definition of the table relation.