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
- 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
- 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
Options
Problem with Lookup
deepblue
Member Posts: 152
Hello!
I have created a card form where the Field "No." is the Primary key in the table. when I open the Lookup Form and choose another value to go to another record the system try to change the value of the field and an error message saying that "the record already exisits" appears.
What can I do?
Thank you!!!
I have created a card form where the Field "No." is the Primary key in the table. when I open the Lookup Form and choose another value to go to another record the system try to change the value of the field and an error message saying that "the record already exisits" appears.
What can I do?
Thank you!!!
0
Answers
RIS Plus, LLC
1. Could it be that you have a Table where the Primary Key Field is Related to the Table Itself?
If this is the case, It is Wrong.
2. if what you are trying to do is to select another Record, then it is NOT done on Lookup(of the Primary Key) but on the List Form (Generally F5). This List form Must have been specified on the LookUpFormID Property of the Table.