Filtering table in subform

StefanWeinreich
Member Posts: 2
Hey all,
i need to filter data shown in a subform.
The subform simply contains telephone-call-data.
In the mainform exists a control where the user can select a certain phonenumber, so only the call-data from this certain number shall be shown in the subform.
That means i have to filter the data in the subform and to update it.
How can i provide this ?
thanks in advance
STEFAN
i need to filter data shown in a subform.
The subform simply contains telephone-call-data.
In the mainform exists a control where the user can select a certain phonenumber, so only the call-data from this certain number shall be shown in the subform.
That means i have to filter the data in the subform and to update it.
How can i provide this ?
thanks in advance
STEFAN
thanks in advance
STEFAN
STEFAN
0
Comments
-
I don’t know exactly what you mean, but try this.
1.) Name you subform on the mainform. (Properties of subform/Name)
2.) Make a function in the table of the subform in witch you set your filters.
3.) Call that function in a new function in the subform.
4.) Call that function from the mainform.
You can do it like this:
CurrForm.Saleslines.FORM.SetTelFilter();
Saleslines is the name of you subform. (Step 1.)
SetTelFilter is the name of the function on your form. (Step 3)
You can use parameters to make your filtering variable.
Good luck!
Greetz,
Emiel Romein
The Netherlands"Real programmers don't comment their code.
If it was hard to write, it should be hard to understand."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