>Is there any reason why you cannot use sequential numbers a a key? Take a look at article Primary Keys by Craig Berntson http://www.craigberntson.com/Articles/kb006.htm.

I will read up on it Sergy. Thanks.

>Back to your code. The Update -SQL w/o where clause updates all records in the table. To update current record only use Replace commnad.
>

Since that is a new field and is currently empty, should I be using Update or Insert. The other two fields in the record contain values.

Thanks.