Subform Linking from Subform to Subform
eskay
Member Posts: 11
Hello there,
is it possible to realize a relation from a subform line to new subforms related not to the
headerform.
through the properties I can place a SubFormID / Subform Link which is related to the header
form.
Im my sample the prod order lines has a relation to prod. order routing line and prod. order component.
So I need to realize a view where I can step through the Prod. Order lines and see in the related
Subforms the according routing lines and components for each production step.
Is this possible?
Thanks
Siggi
is it possible to realize a relation from a subform line to new subforms related not to the
headerform.
through the properties I can place a SubFormID / Subform Link which is related to the header
form.
Im my sample the prod order lines has a relation to prod. order routing line and prod. order component.
So I need to realize a view where I can step through the Prod. Order lines and see in the related
Subforms the according routing lines and components for each production step.
Is this possible?
Thanks
Siggi
0
Comments
-
Hi eskay,
for Sub Form Link you can use following :
Step 1. Set Main Header form TimeIntervel Property with 10
Step 2. Now Create a function with Main Form Called MainForm1Function(Line1 record varibale Passing);
MainForm1Function(Line1 : Record "Line 1");
{
Line2.SETRANGE(Field1,Line1.field1);
Line2.SETRANGE(Field2,Line1.field2);
Line2.SETRANGE(Field3,Line1.field3);
CurrForm.SubSubForm.FORM.SETTABLEVIEW(Line2);
}
Step 3. Called fllowing lines in Main Form's OnTimer Trigger.
Form - OnTimer()
{
IF NOT CurrForm.SubForm.FORM.IsSelectedLineChanged THEN
EXIT;
CurrForm.SubForm.FORM.GETRECORD(Line1);
MainForm1Function(Line1);
CurrForm.SubSubForm.FORM.UpdateForm;
}
Step 4. Set SubFormLink Property of SubSubForm with SubForm Fields.
Hope above code will help you...
all the best
0 -
Your first subform should just include your second and third subform. That means you'll have one main form and one subform. This subform consists of one main form (list) and two subforms. You just need to set Width and Height of your first subform to a proper value."Money is likewise the greatest chance and the greatest scourge of mankind."0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 324 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