Applying Filter from Header to Lines

Betrachter84
Member Posts: 62
Hi
Im developing some new tables and forms similar to for example purchase header and purchase line.
My header table has a unique id called "No.". the correspomding field in the line table is called "Header No."
Now my problem. When i flip through the records in the header form i only want to see the line records in the subform wich belong to the actual header. eg. when the current record in the header has "No." = 1000 then i only want to see all the lines with "Header No." = 1000.
How can i apply filters to the line table in order to showing me allways the records correspomding to the actual header? And where do i have to put the filter expression on a trigger of the header form, or the header table? I looked through the code of the purchase tables and forms, but didn't find the clue...
Thanks for your help.
Im developing some new tables and forms similar to for example purchase header and purchase line.
My header table has a unique id called "No.". the correspomding field in the line table is called "Header No."
Now my problem. When i flip through the records in the header form i only want to see the line records in the subform wich belong to the actual header. eg. when the current record in the header has "No." = 1000 then i only want to see all the lines with "Header No." = 1000.
How can i apply filters to the line table in order to showing me allways the records correspomding to the actual header? And where do i have to put the filter expression on a trigger of the header form, or the header table? I looked through the code of the purchase tables and forms, but didn't find the clue...
Thanks for your help.
0
Answers
-
have you set any SubformID & SubFormLink?0
-
look in the properties of the subform that is on the header form0
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