>>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.

It doesn't metter for REPLACE command if field is new, empty or whatever. It'll replace it with a new value. The same is true for UPDATE-SQL command. The inser command will add a new record to the table.