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
- 309 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 problem
axisdata
Member Posts: 3
Hi!
I have a table with a field "table-related" to another table field and both properties "test table relation" and "validate table relation" are set to 'false' (this field is not part of the table's primary key), like in this simple example:
- main table : "room conditions" -> field "room type" (amongst others)
- lookup table: "room types" -> field "room code" (amongst others)
The property "TableRelation" in the filed "room type" from the main table is set to: "room types"."room code" and i have these room codes registers:
__________
Room Code
__________
DBTTM
DBTT
DZ
.
.
.
.
etc
... The problem i'm having is that when i try to retrieve 'DBTT' room code it automatically exchages 'DBTT' with 'DBTTM' and there's no way i can insert the 'DBTT' code, (even if type it directly without using F6) but deleting the DBTTM register from the lookup table (which is not a proper solution... don't you think?), or changing the primary key (which is not possible at this stage of the application project). As I said before, both 'validate table relation' and 'test table relation' are set to false.
The last I tried was making lookup conditions manually by code on the lookup trigger of the field, but I came out with the same problem... and i ran out of ideas.
i hope someone can help me with this...
Thanks in advance!!!
I have a table with a field "table-related" to another table field and both properties "test table relation" and "validate table relation" are set to 'false' (this field is not part of the table's primary key), like in this simple example:
- main table : "room conditions" -> field "room type" (amongst others)
- lookup table: "room types" -> field "room code" (amongst others)
The property "TableRelation" in the filed "room type" from the main table is set to: "room types"."room code" and i have these room codes registers:
__________
Room Code
__________
DBTTM
DBTT
DZ
.
.
.
.
etc
... The problem i'm having is that when i try to retrieve 'DBTT' room code it automatically exchages 'DBTT' with 'DBTTM' and there's no way i can insert the 'DBTT' code, (even if type it directly without using F6) but deleting the DBTTM register from the lookup table (which is not a proper solution... don't you think?), or changing the primary key (which is not possible at this stage of the application project). As I said before, both 'validate table relation' and 'test table relation' are set to false.
The last I tried was making lookup conditions manually by code on the lookup trigger of the field, but I came out with the same problem... and i ran out of ideas.
i hope someone can help me with this...
Thanks in advance!!!
0