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
Problems with OnLookup trigger
OrangePie
Member Posts: 11
Hi,
I'm quite new to NAV and while trying to filter the OnLookup list I stumbled across some difficulties. I want to limit the number of possible choices, let's say workers, when unrolling the OnLookup list on page. I tried following the guide that seemed to help to achieve a similar result though it didn't quite work for me.
Could anyone point me in the right direction? I played with some built-in functions but a simple SETRANGE doesn't seem to do the trick.
I'm quite new to NAV and while trying to filter the OnLookup list I stumbled across some difficulties. I want to limit the number of possible choices, let's say workers, when unrolling the OnLookup list on page. I tried following the guide that seemed to help to achieve a similar result though it didn't quite work for me.
Could anyone point me in the right direction? I played with some built-in functions but a simple SETRANGE doesn't seem to do the trick.
0
Comments
What version of NAV/BC are you using?
Say I have a table and one of its fields is related to data in another table. On page I want to filter the OnLookup list to show only those options in that field that have a certain parameter set to TRUE.
I tried applying some filters but to no avail.
After writing the post I found this though: https://forum.mibuso.com/discussion/2588/filtering-a-lookup
Can you at least explain to me where tblItem came from? is it built-in? I didn't find any information in my materials.
Some field - OnLookup() //written in table object MyTable.SETRANGE("Filter Field", TRUE); //set your filter on the target table IF PAGE.RUNMODAL(0, MyTable) = ACTION::LookupOK THEN //RUNMODAL means it will be run "on top", i.e. you won't be able to progress until you are finished with the new window //parameter 0 means that it must open page specified in the table's (MyTable) "Lookup Page ID" property //parameter MyTable points to the record we want to open the page with (specific filtered table) //ACTION::LookupOK means that we will only execute the below code if the page is closed by pressing "OK" button at the bottom-right VALIDATE("Some Field", MyTable."Target Field"); //this is because you most likely want to save the value you looked up, in this case to the "Some Field"No PM,please use the forum. || May the <SOLVED>-attribute be in your title!