I ran into this problem today and was wondering if anyone
can give some ideas on how to handle this...

In the scenario:

Customer_Num I - Identity Key
Customer_Name C(15)

If I insert Into the SQL Server database using a remote
view, I do not know the Customer_Num. In Order to
get the current result set I would need to =Requery() the
Remote View. When I requery() the remote view, the
record pointer moves. Since I do not know the
Customer_Num key, how would I know where to return the
record pointed to?

This becomes more of a problem if the View is ordered, and
the returned REQUERY Set had the new record in the middle or so...

Locateing for the Customer_name is not really any option
Since we could possible have the same name for different customer
#'s...

Anyone have any thoughts on this?

Bob