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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
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
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...