You can do one of two things:

1. Generate the key in VFP so you don't depend on SQL Server to do this.

2. Save updates to your parent table and then issue a SELECT @@IDENTITY AS 'Identity' via SQL pass-through to get the last key that SQL Server generated.


>I'm having a little trouble with primary keys and remote view to SQL 7 server.
>
>If I have a parent table and I APPEND BLANK to the view I don't have a primary key yet because SQL hasn't generated the key yet. That means I can't tie in any child records. To compound the problem my view needs to be parameterized on the key. The irony is I can't requery my view to get the key because the parameter to the view is that key.
>
>If anyone knows what I'm talking about and can help, message me a soon as you can.
>
>thanks,
>
>Greg Moss
>www.siteproposals.com