DSP: store of 1/many
Author: email@example.com (osie_osie)
My problem is that the foreign key of a painted entity is not inheriting the parent values which are set in the write trigger.
I have painted a 1/many.. autogenerated by 'copy as html'
In the presave trigger I default 0 as the value of the PK for both entities
In the write trigger of the parent I set the PK using 'sql select max(PK_NO) +1' .
The result is that the child entity picks up the parent value after issuing an error in the write trigger as the related field is 0 before the write command.
The only way to resolve the problem is by explicitely setting the inherited field with the parent value... which is normally a big no-no
Any help will be much appreciated