error:Record already exist?

mdsr

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


thanks in advance

bbrown

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"

mdsr

@bbrown i have tried what you said but still getting same error

lubost

1. What your primary key looks like?
2. What your page properties looks like?

mdsr

primary key item no.
i have not set other properties on page than bbrown said

lubost

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