In addition to all the other replies you received I reccomend you to look into the new auto increment field type in vfp8. If using this field type fits into your application I would reccomend using it.

Einar

>how can i not allow duplicate entries in my table? i have an add and save button in my form. add does an append blank, then save does the tableupdate. if record is already in my table, i don't want to do a tableupdate.
>
>pls help. TIA.