>I think that is what I am doing. The two fields are a compound primary key
>and are:
>
>PCAT_UNIQUE_REF
>PCAT_SYSTEM_REF

A compound key where one of the elements is populated by a generator? I
suppose it ought to work, but it is a rather unusual situation. Does it
work any better if you reduce your PK to just PCAT_UNIQUE_REF (the
generator should assure its uniqueness)?

Set