Auto Fill in Navision 3.60

A._B._Computer_Systems
Member Posts: 103
Is there a way in Navi 3.60 to have for example the customer number to Auto Fill the rest of the code as soon as it is unique? So let's say you are entering a customer number 123456. As soon as you entered 123, the system realizes that there is only one customer that starts with 123 and then fills in the rest for you.
:?:
:?:
0
Comments
-
HI 1302!
if i understood well, you can achieve that by setting a table relation between the field you want to 'auto-fill' and a field on a lookup table where the codes to check are... by default (check that TestTableRelation is false) it will auto-fill the value with the first value starting with the characters you typed...
BUT!!! note that if you have for example these codes, and in this order:
1 12345
2 123
3 1234
when you try to enter '1234' code by just typing 123, it will take the first value corresponding to '12345' that's precisely the problem i am having and the subject of a message a posted this week. So it's better, as long as you have no solution to this, to set up the codes you want to be automatically filled with a significant difference amongst them.
... something like this
EXAMPLE CODES (which won't "confuse" the auto-fill feature)
1 PT
2 MBX
3 STV
4 MKTS
i hope this helps you...0
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