Entering values directly vs. a list box

MarkKeener
Member Posts: 17
Hello,
I have kind of an odd question - Is it possible to have Navision determine whether a value was typed into a textbox or if the value was selected from a look-up window.
I have a customer that will be using Item Cross-Reference numbers. There may be instances where the same cross-reference number may point to several different item records. I want the system to display the look up window if the user types in a cross-reference number for which there are several records in the item cross-reference table that have the same cross-reference number pointing to mulitple items.
BUT, if the user selects a specific record from the cross-reference list, I don't want the system to do anything except it's normal processing. I am aware that I can put code in the OnValidate trigger that will open the list box. BUT, won't that same code execute when I make a selection from the list box?
What I am trying to figure out is how I can tell Navision that the user made a choice from the list rather than directly typing into the textbox.
I'd like to do this at the table level instead of adding code to a form if at all possible.
Thanks for any help anyone can give me.
I have kind of an odd question - Is it possible to have Navision determine whether a value was typed into a textbox or if the value was selected from a look-up window.
I have a customer that will be using Item Cross-Reference numbers. There may be instances where the same cross-reference number may point to several different item records. I want the system to display the look up window if the user types in a cross-reference number for which there are several records in the item cross-reference table that have the same cross-reference number pointing to mulitple items.
BUT, if the user selects a specific record from the cross-reference list, I don't want the system to do anything except it's normal processing. I am aware that I can put code in the OnValidate trigger that will open the list box. BUT, won't that same code execute when I make a selection from the list box?
What I am trying to figure out is how I can tell Navision that the user made a choice from the list rather than directly typing into the textbox.
I'd like to do this at the table level instead of adding code to a form if at all possible.
Thanks for any help anyone can give me.
0
Comments
-
If you code your lookup into the OnLookup trigger for that field on the table, then the field validation trigger is not called when you use the lookup form.
So you could have your "if user types in" code on the validate trigger and then your "user used lookup form" in your lookup trigger. And hopefully they wont overlap.
Hope this helps you out a bit.This isn't a signature, I type this at the bottom of every message0
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