>>Do you also have an insert trigger on the woSF table in the main DBC also calling getNextKey()? That would cause the function to fire when the record was physically added to the table (I tried it to make sure).
Nope, No triggers.
>Of course the trigger would probably react the same from the command window unless it had conditional logic that kept getNextKey from firing.
>
>I tried your scenario (in a simpler structure) and mine worked fine from the Command window and form. Zip and email me your stuff if you want and I'll take a look. scott@evermac.com
Since my form is rather complex, this prompted me to make a simpler version. I think I found the problem. I wan't using APPEND BLANK, I was using INSERT INTO, and it seems that was causing the problem. I switched to APPEND BLANK and the problem went away.
Thanks for the help.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!