I really like that VFP finally has an auto-increment type built-in. So I'm now trying to utilize it and I'm having the similar type of issue I had with MS SQL.

In a view I append a blank record but the new key hasn't been generated yet. So I can't tie in the child records. Even if I do a table update it doesn't move the keys in.

I know several workarounds... But I just wanted to find out what the 'preferred' way was to handle that situation. Is there a VFP function like there is in MS SQL that you can use to find the key value that was generated?

It would also be nice to have a methodology that would be easy to up-size to SQL Server later.

Thanks in advance!

Greg