Best case, this is a slow way to calculate primary keys. Worst case, as Sergey said, it won't work in multi-user environment. Check out article on
www.craigberntson.com on primary keys...since your table is free, you don't have default value, and you will have to call the function manually.
>Sergey,
>
>Thank you. Calculate is exactly what I was looking for. I am
>trying to determine the Next Unique ID and this allows me to bypass creating a cursor and placing the resulting cursor value into a variable. This is in VFP6 and the table is a free table.
>
>If you have any suggestions about a better way to get this value I would appreciate it.
>
Steve Gibson