Howdy, Stranger!
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
- 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Lookup after manual text input in textfield of form
Knutsen
Member Posts: 7
Hi there,
I have got a form displaying several records ("BANF Line"). The records and the form contain two references to "Item". Our "Item" has been extended with an additional (external) product number. So the Item.No is still primary key, but the external product number is unique too.
So the form has two columns for the two product numbers. The first column ("No.") uses the automatic lookup feature, but the second doesn't of course. I managed to implement a manual lookup for the external product number. Therefore the user can click on the lookup arrow, search for the corresponding item and select it. But many users already know the product number and would like it to enter it directly into the text-field. Without additional code I'm getting the message, that the external product number isn't part of the primary key, which is correct of course. But I don't want to alter "Item" and the primary key... When I'm trying to change the OnAfterInput-Trigger and putting some manual lookup-code into it, I'm getting the message, that I cannot change the database before opening a transaction. That's because I tried to validate the Item.No when finding the corresponding Item for the external product number, and Navision doesn't allow that...
Does anybody have a hint, how I manage to update the record in my form after a direct input into the text-field?
I have got a form displaying several records ("BANF Line"). The records and the form contain two references to "Item". Our "Item" has been extended with an additional (external) product number. So the Item.No is still primary key, but the external product number is unique too.
So the form has two columns for the two product numbers. The first column ("No.") uses the automatic lookup feature, but the second doesn't of course. I managed to implement a manual lookup for the external product number. Therefore the user can click on the lookup arrow, search for the corresponding item and select it. But many users already know the product number and would like it to enter it directly into the text-field. Without additional code I'm getting the message, that the external product number isn't part of the primary key, which is correct of course. But I don't want to alter "Item" and the primary key... When I'm trying to change the OnAfterInput-Trigger and putting some manual lookup-code into it, I'm getting the message, that I cannot change the database before opening a transaction. That's because I tried to validate the Item.No when finding the corresponding Item for the external product number, and Navision doesn't allow that...
Does anybody have a hint, how I manage to update the record in my form after a direct input into the text-field?
0
Comments
You could try using the AltSearchField property on the No. field of the Item table
I have changed the AltSearchIndex of Item.No. from "Search Description" to the field of our external product number, but it doesn't work out... the message stays. Afterwards I have set TableRelation=Item (before Undefined) and Lookup=Yes (before No) of the Properties of the FormField, but it hasn't any effect either.
You would enter the external item no. in the Item No. field
erm... yeah, right. :oops:
Thanks, it's working! :thumbsup: