Transfer Value boolean field from one table to another table

gpj

Hi There,

I want to transfer the value of a boolean field from the ItemTable to the same boolean field in the SalesLineTable.
(Fieldnumbers are different in both tables)
For instance: when I insert a line in the SalesLineTable it should transfer the value from the Itemtable to the SalesLineTable.

I Put the following code In the OnInsert section in the SalesLineTable:

IF Item.GET("No.") THEN
SalesLineTable.Fieldname := ItemTable.Fieldname;

What am i doing wrong ?

I appreciate your help.

kapamarou

Is it a typo?

IF Item.GET("No.") THEN
SalesLineTable.Fieldname := ItemTable.Fieldname;

IF Item.GET("No.") THEN
SalesLineTable.Fieldname := Item.Fieldname;

gpj

kapamarou,

Thanks for your reply.
I allready found out what went wrong.
After i confirmed the line in the salesline table (arrow down) the value was tranferred correctly.

Thanks anyway.

Savatage

it's even easier then that. if you look on the onaftervalidate of the "no" field and scrolldown thru the code you will see a number of fields from the item table being transfered ie/description. add your one line of code there. no if get needed.

gpj

Ok Harry,

I also tried your suggestion and I must say this works better then my code.
I 'll do it your way !

Thank you too...