record already exists issue.

Suds
Suds Member Posts: 22
edited 2011-08-31 in NAV/Navision Classic Client
I'm wondering if I'm over looking something simple.
When trying to enter a new Category Code it gives me the error "record already exists" when it clearly does not. It won't let me enter any type of combination of letters or numbers.

I'm hoping it is just a simple slip on my part but any help will be much obliged,

Suds.

Comments

  • Sog
    Sog Member Posts: 1,023
    I'm sorry, but there is not enough information in your question/description to help you at all.
    Could you tell us what record you are trying to insert? If it is not Item Category or Unsynchronised Category then it is a custom table and then we need a lot more info.
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • Suds
    Suds Member Posts: 22
    Sorry sog,

    it is an Item Category that we're having an issue with.
  • DenSter
    DenSter Member Posts: 8,307
    That's what the debugger is for. Turn on the debugger and try to insert a record. Step through the code and see what happens.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • -matrix-
    -matrix- Member Posts: 103
    Did you check if are there any filter on the table?
  • Yashojit_Pandhare
    Yashojit_Pandhare Member Posts: 38
    Hi..

    Please check the following:

    1. Check if any filter is applied to the table, and the value you are entering is already present but not showing due to filter.
    2. Check the Keys applied to the table. Ensure that all the key fields are visible on the Item Category form.
    3. It may happen that, there is a key field not inserted on form, so for first record it would be blank, and the same would happen for another record, thus the error, as the key value is not unique.
    :idea:

Categories