Field No. 6862616 is not defined in table ...

Fermi
Fermi Member Posts: 27
edited 2013-10-31 in NAV/Navision Classic Client
Hi, friends!

I'm working in MBS 3.70 running over SQL. I've made some forms from the same table. They filter the table for some different values of one field. When I want to create one new record in a form in which there are not records, I can see the Series No. form, where I can select the numeration series for my new record. When I select one, MBS suddenly closes my form, and shows the error message that is the title of this question. In spite of that, the new record is created after all.

It only occurs when I'm creating one new record and there is not any record in the filter defined by that form. If any other record is showed in the form, and I press F3 and select a numeration series, this problem doesn't exist.

I would be grateful to you for your help.

Thanks in advance.

Best regards.
Best Regards,

Manuel Barral Paul

Comments

  • kine
    kine Member Posts: 12,562
    Where will stop debugger, if it is running in time of error?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Fermi
    Fermi Member Posts: 27
    Unfortunately, debugger doesn't stop anywhere. I've tried that, but without results. Besides, that field doesn't exist in the table source of the form.
    Best Regards,

    Manuel Barral Paul
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    It looks like a tablerelation/flowfield which is not correctly defined.

    Can you export all objects to a text file and look for this number?
    Marije Brummel | Freelance Business Central Specialist
  • DenSter
    DenSter Member Posts: 8,307
    It looks to me that the form has a reference to a field that does not exist in your database. Open the form in the designer and press F11, it'll probably give you a compile error, and it should take you to the textbox that causes the error.

    The other option is that the table you are displaying is supposed to have that field and doesn't. In that case just add the field to the table.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Fermi
    Fermi Member Posts: 27
    Hello again.

    I've tried to export all objects in database to txt, and the field 6862616 doesn't exist anywhere.

    After that, I've added that field to the table. The result was the same error, but with another field number in the error message. I've created that field, and the error kept existing until I'd created 4 fields. In that moment, the error disappeared.

    It's a quite strange thing, but I hope that the problem is solved.

    Thanks a lot.
    Best Regards,

    Manuel Barral Paul
  • Charles_Chew
    Charles_Chew Member Posts: 1
    Hello~ I face the same problem but with different field in different table in NAV 2009 R2. I added in a new field at table 38, the error prompt after I modify the page. Does anyone know what is the actual cause even the field is existing?

Categories