>From any place of your app when you need in new key value, you just issue:
>nNewkeyvalue=getnewid("mytable")
>and evaluate return value.

Ed,
I am running Active Server Pages with VB Script
and the VFP trigger does NOT execute when inserting
records. Wahhhhhh. It's just like any true backend
server, you have got to have the server running
to add records that understands the language. Since
VFP isn't a server, it can't be done.

Also, in web development, calling a table to
look up keys is very time consuming to the end-user.
Web developement reminds me of the programming
15 years ago. It's ancient and slow.

The only way to have an increment key using
VFP free table on the web is to use an
Apllication Variable that does the increment.

I wish I could use VFP for the development
but Microsoft forces us to us VB. I guess
VFP is going by the wayside and one way
or another, MS will force us to change to VB
or another vendor's language. I've begun
to study up on Fortran. <g>

Thanks for the reply.