Problem with Lookup

deepblue
deepblue Member Posts: 152
edited 2006-04-13 in NAV/Navision Classic Client
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!!!

Answers

  • DenSter
    DenSter Member Posts: 8,307
    Turn on the debugger and step through the code. It seems to me like you put some code in form triggers that tries to insert a record that already exists.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • sgg
    sgg Member Posts: 109
    What is the Value of the TableRelation Property of the Field "No." ?

    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.
    Sunday, Godwin G

Categories