Error message when create new record

moneim

hello !
I created a document page based on new tables (pict001)
but when i trying insert new group from the list (pict002) ,an error message is browsed (pict003)

someone can help me plz ???

tables used :
country group (code ,name) //Header
country group line (country group code,country code,country group name,country name)
//country group code from table group and country code from table country

rocatis

Try to set DelayedInsert=Yes on your "List of Countries" page.

udayrmer

I think you had wrongly linked subform with the table,

can you please share primary key of both the table, and subform link relation.

one more thing, try setting subform property DelayInsert = true

moneim

I set delayedinsert = true in my page list and my subform but the same error message appears .

I screen print my tables structure and my subform with properties

someone have idea plz ??

thx

Belias

what's the page type of your subform? it should be listpart.

udayrmer

Have you defined any Testfield On OnOpenForm, or OnafterCurrRecord, Or OnafterGetRec ?

moneim

My page subform is of type listpart and I don't use Testfield

udayrmer

any coding is there on line table or form ?

moneim

Ohhhh ! yes I have Testfield in my table Group Line in trigger OnValidate() :^o
I deleted it and it works now

Thank you mibuers =D>

udayrmer

You are always welcomed

beran

I saw a comment on using DelayedInsert on a header in the header/line pattern. This has to be done with carefullness. Currently in the released Beta version of 2013 you will the action with no error but it will return in the final version 2013.

As said with carefulness the Delayed Insert can be used in the header/line pattern. For instance you can find it in the User table in the final release of Nav 2013. It does not set the key value in the OnNewRecored but in the OnInsertRecord.

The reason getting this error is that the execute data fetch is called WHEN the filter has changed. The filter is changed when you fill out the key in the header which is connected to the filter on the line. But the record has not been saved yet so therefore you get the error. It will close the page going forward.