Re: Trigger question

Maybe Mapics list because I don't understand the two item master concept.
Is one Mapics supplied and the other user supplied (like extra fields)? Is
the second one supposed to be updated by the trigger on the first one, or,
does the application program update both and you only want to fire off the
trigger after both updates have occurred? For example, does the
application do something like
update itemmast1 %fields(field1: field2);
update itemmast2 %fields(field3: field4);
and you only want the trigger to fire off after the second update?

You can "assume" that the only updates come from the application program
and just put the trigger on the second file, chain back to the first file
and process combined data.

Trigger on itemmast1 could check a "processing file" for key. If no key,
write row. If key, update row and process.
Trigger on itemmast2 could check same "processing file" for key. If no
key, write row. If key, update row and process.
Cleanup would determine what to do with rows in the processing file that
have been there for so long and didn't get the update from the other file.

Rob Berendt