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
- 262 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
Opening pages from code after setting filters (NAV 7/8/9)
EvR
Member Posts: 178
Hi all,
I'm sure this question has been asked before and I'm sure it is dead simple but I can't seem to figure out a basic page-flow.
Imagine the following situation:
- A new table, let's call it 'Item Image' consisting of the fields:
Item No. (code) (PK)
Index (int) (PK)
FileName (text)
Data (BLOB)
- A new list page called 'Item Image List' based on 'Item Image' containing the Index and FileName fields.
- A flowfield called 'Images' has been added to the 'Item' table, containing a count to get the number of 'Item Images' which have a relation to the current Item No.
What I want to do next, is display the 'Images' property on the Item Card. On click I want to open the 'Item Image List' page with a filter on the current Item No.
When inserting a new record in the 'Item Image List' page, I want it to be inserted with the Item No. that's currently in the filter from the Item Card.
What I'm doing at the moment is giving me issues while inserting new records. It does not honor the filter I've set:
(OnLookup behind the 'Images' field on the Item Card.)
ItemImage.SETRANGE("Item No.","No.");
ItemImageList.SETTABLEVIEW(ItemImage);
ItemImageList.RUNMODAL;
CurrPage.UPDATE;
Could someone point me to the preferred way of doing this IN NAV? Thanks!
I'm sure this question has been asked before and I'm sure it is dead simple but I can't seem to figure out a basic page-flow.
Imagine the following situation:
- A new table, let's call it 'Item Image' consisting of the fields:
Item No. (code) (PK)
Index (int) (PK)
FileName (text)
Data (BLOB)
- A new list page called 'Item Image List' based on 'Item Image' containing the Index and FileName fields.
- A flowfield called 'Images' has been added to the 'Item' table, containing a count to get the number of 'Item Images' which have a relation to the current Item No.
What I want to do next, is display the 'Images' property on the Item Card. On click I want to open the 'Item Image List' page with a filter on the current Item No.
When inserting a new record in the 'Item Image List' page, I want it to be inserted with the Item No. that's currently in the filter from the Item Card.
What I'm doing at the moment is giving me issues while inserting new records. It does not honor the filter I've set:
(OnLookup behind the 'Images' field on the Item Card.)
ItemImage.SETRANGE("Item No.","No.");
ItemImageList.SETTABLEVIEW(ItemImage);
ItemImageList.RUNMODAL;
CurrPage.UPDATE;
Could someone point me to the preferred way of doing this IN NAV? Thanks!
0
Comments
I cant find anything wrong with your code as you describe it. It should work. It does work with classic forms.
I suggest, though, to set your Item Image List page as DrillDownPageID for the Item Image table, rather than programming a lookup on the page.
Do you have any code in the OnInsert trigger on the page or table?
Is the fault indeed with the inset into the Item Image Table or rather with the update of the FlowField on the Item Page?
RIS Plus, LLC
MVP - Business Apps
The reason I 'need' to do it through code, is that I want the count flowfield to be updated after inserting new records in the related list.
If I use the drilldown page id, the flowfield does not update after closing the list. Which could be confusing to the end user.