Thanks Lester,

I'm red faced. Helen (I think it was) told me this 6 or 9 months ago.
Forgot. Problem only programming every few months or so.
You are also quite right about my over-complicating it from what
Helen has writen below.

Rgds,

>
> BECAUSE Field2 is in your SQL it MUST have a valid value. The

DEFAULT

> will only be used by Firebird when Field2 is missing from the

query. By

> putting it in the query you also need to supply a value for it.
>
> Helen will probably slap my hand ;) but I think that you are being
> pushed to do things that are far more complex than is needed. I

have YET

> to use OnNewRecord! The blank new record is created by the

defaults set

> up in the database, GeneratorLinks creates the record for me and

gives

> me a key to the new record, and all of the rest happens

automatically :)

>
> --
> Lester Caine - G8HFL
> -----------------------------
> L.S.Caine Electronic Services - http://home.lsces.co.uk
> Model Engineers Digital Workshop -
> http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
> Treasurer - Firebird Foundation Inc. -

http://www.firebirdsql.org/index.php

>