Actually it was more simple. I used automatically generated
UpdateSQL sentences and there was 1 row missing. Update SQL
is generated without primary key fields, but I wanted to
change this value.

UPDATE MAKSED SET
KMAKS = :KMAKS,
SUMMA = :SUMMA,
KULU=:KULU <<--- this row
WHERE
AASTA = :OLD_AASTA AND
KORTER = :OLD_KORTER AND
KULU = :OLD_KULU AND
KUU = :OLD_KUU


Riho-Rene Ellermaa
Ellermaa Tarkvaratöökoda
http://www.ellermaasoft.ee

>
> I think the relationship between the main dataset and the

lookup dataset is suspect anyway., because the KeyLinks
linkage from the lookup dataset to the main dataset
references itself, through the join. IOW, i think it's
possible this can't work like this, i.e. changing this
value would violate all of the contributing relationships.
It's a circular reference.

>
> fwiw
>
> Helen
>