Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
keep field constantly updated with values from another table even if it changes
cross
Member Posts: 10
I am feeding a field with the sum of the quantities of another table, however, I need to know how to keep this field updated if the field of the table that feeds it changes its value? because after it is full and it changes, it does not update.
I still don't have code for this, I just want to know how to perform this procedure or in what way or option it is used.
I still don't have code for this, I just want to know how to perform this procedure or in what way or option it is used.
0
Best Answer
-
Options
Resolus
Member Posts: 40
What version of Nav/BC are you using?
In my opinion there are 2 options.
1. You could use a flowfield.
This will calculate the sum on the fly and therefor it'll always be correct.
You just need the right filters on the flowfield.
However flowfields might be a bit slower if it's a lot of records.
2. You could work with subscribers.
Create a function and subscribe to the OnAfterModify event of the table from which you want the sum of quantities.
Then in the function you simply put your filters, get the sum and save it into the correct table/record.
But which option is best depends on what you want to use it for/how large the second table is.
This is just my opinion.6
Answers
In my opinion there are 2 options.
1. You could use a flowfield.
This will calculate the sum on the fly and therefor it'll always be correct.
You just need the right filters on the flowfield.
However flowfields might be a bit slower if it's a lot of records.
2. You could work with subscribers.
Create a function and subscribe to the OnAfterModify event of the table from which you want the sum of quantities.
Then in the function you simply put your filters, get the sum and save it into the correct table/record.
But which option is best depends on what you want to use it for/how large the second table is.
This is just my opinion.