how to filter a list through two filters f->f->display list.
sagablade
Member Posts: 4
Hi every body,
I'm newbie in nav and i have a question about filters.
I want to filter a list(in form) with two filters, the first filter is filtering with "job No" and the second filter is filtering with "job Task No" but displays only the "job Task No" of the "job No" chosen in the first filter.
Thanks in advance.
I'm newbie in nav and i have a question about filters.
I want to filter a list(in form) with two filters, the first filter is filtering with "job No" and the second filter is filtering with "job Task No" but displays only the "job Task No" of the "job No" chosen in the first filter.
Thanks in advance.
0
Comments
-
Not sure I follow...I'll take a shot
Got to your list form. click on the column you want to filter. hit f7 and enter your filter value, click ok.
now you list is filtered. now click on the second column you want to filter by. hit f7 and enter your filter value, click ok.
now you list if filtered by two filters.
is this what you mean?0 -
I think what he means is the Job number textbox looks up to the full Job list, and the Task number one looks up to the task list, but filtered by the value of the job number.
If you have the Job number and the Task number as fields in one table, and you set the links correctly, the lookups should work without a problem. If you only have unbound controls on a form then you will have to program the lookup manually.0 -
So I assume that those textboxes are not fields in the source table. The textbox control has a source of a code type variable, that gets set to the Job's "No." field, let's call it JobNo, with datatype Code20. In the Task lookup, you use the value of that variable as a filter in the lookup to the task. The source of that textbox is another variable, let's call it TaskCode, data type Code10. I am writing this off the top of my head, you will need to go into the table design of the tables, and make sure that the variables have the same data type as the fields you want to link to.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
- 322 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
