error:Record already exist?

mdsr
mdsr Member Posts: 163
edited 2019-10-02 in NAV Three Tier
hi I have created table QC Master and corresponding page
field :item no.
: test method

when i run and add item in item no. field it takes value but when next record i added same item on item number field it giving me error Record already exist
why so?i need to add multiple test method for same item in table/page
09gz1w2uji40.jpg

thanks in advance

Answers

  • bbrown
    bbrown Member Posts: 3,268
    Set the DelayedInsert property of your page to TRUE. So the record does not insert until you move of the line and have entered your "Test Method". Also be sure your table has a 2 part primary key. Perhaps "Item No.", "Test Method".

    You may also want to set those 2 fields to "Not Blanks"
    There are no bugs - only undocumented features.
  • mdsr
    mdsr Member Posts: 163
    @bbrown i have tried what you said but still getting same error
  • lubost
    lubost Member Posts: 633
    1. What your primary key looks like?
    2. What your page properties looks like?
  • mdsr
    mdsr Member Posts: 163
    primary key item no.
    i have not set other properties on page than bbrown said
  • lubost
    lubost Member Posts: 633
    When your primary key is only Item No., you can not insert record for the same item, because NAV requires primary key to be unique. You should add columns to your primary key as bbrown said

Categories