>I have an inventory type table and when I enter a new part, I want VFP to automatically assign a unique part number to it. I know it can be done, is there an easy way. thanks for the help.

Unique IDs are usually controls from a meta table like TABLE.DBF which holds the last unique id used to create a record in each table. This is also used for a locking mecanism.