Helen Borrie wrote:

> Yes; and I should also have mentioned that you must clean up your
> Before Insert trigger if you have not done so already, viz.
>
> IF (NEW.MyTablePK <> NULL) THEN
> NEW.MyTablePK = GEN_ID(GenMyTable, 1);

Make that: IF (NEW.MyTablePK IS NULL) THEN...


Greetings,
Paul Vinkenoog