Howdy, Stranger!
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
- 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 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
Flowfields in Navision 3.70 SQL
zeninoleg
Member Posts: 236
Good day, everybody!
I face an interesting problem. Here is a scenario:
I have a table with following fields:
Number, Field_1, Field_2
Number is a Normal Field
Field_1 is a Flowfield Lookup Description in the Item Table WHERE Item No. = Number
Field_2 is a flowfield Lookup SomeOtherField in OtherTable WHERE Field_123 = Field_1
Is everybody confused yet?
In other words I have a flowfield with the CalcFormula that uses another flowfield.
So as the result I can see that data is shown correctly on the form and in the table BUT when I try to do filtering on the second flowfield I end up with the blank list. #-o
My guess is that Navision flowfields were not meant to be used that way.
All I am trying to do is to avoid doubling the data(updating the fields) across Navision but still give users an ability to filter by the new fields.
Any ideas?
I face an interesting problem. Here is a scenario:
I have a table with following fields:
Number, Field_1, Field_2
Number is a Normal Field
Field_1 is a Flowfield Lookup Description in the Item Table WHERE Item No. = Number
Field_2 is a flowfield Lookup SomeOtherField in OtherTable WHERE Field_123 = Field_1
Is everybody confused yet?
In other words I have a flowfield with the CalcFormula that uses another flowfield.
So as the result I can see that data is shown correctly on the form and in the table BUT when I try to do filtering on the second flowfield I end up with the blank list. #-o
My guess is that Navision flowfields were not meant to be used that way.
All I am trying to do is to avoid doubling the data(updating the fields) across Navision but still give users an ability to filter by the new fields.
Any ideas?
Best Regards,
Oleg
Oleg
0
Answers
Bruno
http://blogs.ittoolbox.com/erp/smb
I just thought there might be a trick...
I quess I will have to work around it.... :whistle:
Oleg
Depending on where you need it (form, report, dataport), you could try some code in the OnAfterGetrecord trigger (don't forget the CALCFIELDS when you use values of flowfields).