fields automatically retrieved when inserting other field

andr3w
Member Posts: 2
Hi all,
I started NAV just a month ago so now i have self-task to make page connected to Customer List (I already done that) but now i must make this Description, Unit Price and Service Item Group fields automatically retrieved when inserting Item No
please tell me how to do this in detailed way
P.S It must be done without CAL code and i guess that i must use Flowfield and CalcFormula
I started NAV just a month ago so now i have self-task to make page connected to Customer List (I already done that) but now i must make this Description, Unit Price and Service Item Group fields automatically retrieved when inserting Item No
please tell me how to do this in detailed way
P.S It must be done without CAL code and i guess that i must use Flowfield and CalcFormula
0
Comments
-
You need to set up the CalcFormula using method Lookup on table Item. You establish the link from your field to the item table using the filter section of the CalcFormula.
Without programming, the calculated fields will not update immediately after you enter the item no. You will have to manually update the form. This is a presentation issue only, because CALCFIELDS is carried out automatically only on fetching the record from the db.
As an example you may have a look at the Report Name field in table 77 Report Selections.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