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

Fermi

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.

kine

Where will stop debugger, if it is running in time of error?

Fermi

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.

Marije_Brummel

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?

DenSter

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.

Fermi

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.

Charles_Chew

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?