Data Exchange between a form and a table

Iwan
Member Posts: 17
Hi everybody
I should copy a variable value from a form to a table. Everthing works but when I insert a new record then the variable value is set back to the inital value.
Is it possible to store the variable value also during the insert process ?
Or is it only possible to store the value, when I create a new field on the table and store the value in the table befor I insert the new record ?
Please help me ?
Greetings Iwan
I should copy a variable value from a form to a table. Everthing works but when I insert a new record then the variable value is set back to the inital value.
Is it possible to store the variable value also during the insert process ?
Or is it only possible to store the value, when I create a new field on the table and store the value in the table befor I insert the new record ?
Please help me ?
Greetings Iwan
0
Comments
-
Hi,
I guess you are using a global variable. I've put a field on 'Resource Card' form (or are you using table form?) I've set its 'SourceExpr' to a global variable.
Once I enter something into the new field and browse through records, value in the new field doesn't change (this is expected). It stays the same even if I insert a new record.
Is this what you are doing or did I get it wrong?http://www.NaviTools.com
Documentation for Microsoft Navision
E/R diagrams, Workflow diagrams, UML diagrams, process diagrams0 -
You can set the variable to the OnInsert() trigger of the form, i.e.
FieldInRecord := NewVariableDeclared_DisplayedOnForm;
I would suggest that you rather use the field in the table as the sourceexpression of the control in the form. Then you don't need to worry about setting the fields in you record using code.
Regards,
Gus0
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