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
- 270 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Lookup (using table relation) Returns A Wrong Value.
superpuz
Member Posts: 53
Hi All,
In NAV 2013, I was trying to create a field that look-ups City from Post Code Table. So I set the TableRelation property on the field (the name of the field is City Name) to "Post Code".City. In My Post Code Table there are Post Codes such bellow:
ID-10310 Jakarta Utara
ID-10440 Jakarta
ID-11470 Jakarta Barat
And there are also many other Post Codes on the table.
When I ran the table (on Windows Client), I have options on how to enter a value to City Name Field.
1. Type the city name directly to field,
2. Select from the drop-down list on the field
3. Type first part of the city name (exp. "jak") so the drop-down list shows all the Post Code, which its city is preceded with "jak", and select from the drop-down list
4. Open the drop-down list by pressing the down arrow on right corner of the field, click advance, filter to search the City that I wanted then press OK.
The problem when using those 4 methods:
1. When I type "Jakarta" and move to other field / record, the value will be set to "Jakarta Utara" instead of "Jakarta"
2. On the drop-down list, I select post code ID-10440, Jakarta, then the value of the field is changed to "Jakarta", but when I move to other field / record, the value will be set to "Jakarta Utara" instead of "Jakarta"
3. Same with method no. 2.
4. Same with method no. 2.
It seems that the table relation caused the field is set to the City on the first Post Code (sort by primary key) which is preceded with the word(s) which user has entered by typing or choosing from the drop-down list or advance look-up window.
Is this a bug?
Regards,
Philipus
In NAV 2013, I was trying to create a field that look-ups City from Post Code Table. So I set the TableRelation property on the field (the name of the field is City Name) to "Post Code".City. In My Post Code Table there are Post Codes such bellow:
ID-10310 Jakarta Utara
ID-10440 Jakarta
ID-11470 Jakarta Barat
And there are also many other Post Codes on the table.
When I ran the table (on Windows Client), I have options on how to enter a value to City Name Field.
1. Type the city name directly to field,
2. Select from the drop-down list on the field
3. Type first part of the city name (exp. "jak") so the drop-down list shows all the Post Code, which its city is preceded with "jak", and select from the drop-down list
4. Open the drop-down list by pressing the down arrow on right corner of the field, click advance, filter to search the City that I wanted then press OK.
The problem when using those 4 methods:
1. When I type "Jakarta" and move to other field / record, the value will be set to "Jakarta Utara" instead of "Jakarta"
2. On the drop-down list, I select post code ID-10440, Jakarta, then the value of the field is changed to "Jakarta", but when I move to other field / record, the value will be set to "Jakarta Utara" instead of "Jakarta"
3. Same with method no. 2.
4. Same with method no. 2.
It seems that the table relation caused the field is set to the City on the first Post Code (sort by primary key) which is preceded with the word(s) which user has entered by typing or choosing from the drop-down list or advance look-up window.
Is this a bug?
Regards,
Philipus
Regards and Thanks,
Superpuz
Superpuz
0
Comments
Is anyone has an explanation / a thought to work around this without killing any TableRelation functionality such as dropdown list which shows options or selection based on the words that user typed.
Superpuz
To lookup by TableRelation to a table with more than 2 fields on its primary key, and not the 1st field of primary key which the value return form the lookup, the lookup could return an invalid value?
Regards,
Philipus
Superpuz