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