>Hi, again.
>
>Going on with my CursorAdapter samples over the Northwind database, I got stuck with another gotcha that I think it should be fairly common, but I couldn't find a decent solution yet.
>
>Nortwinth has the tables Orders and OrderDetails that are parent/child related by Orders.OrderID.
>
>OrderID is an AutoInc Integer (or Identity). Now, in my data-tier, I need to insert a new order, so I do it over CursorAdapter tables, but when the time comes to update, I need to:
>
>1. Update Orders (this would insert the new parent record)
>
>2. Replace all OrderDetails.OrderID with Orders.OrderID
>
>3. Update OrderDetails
>
>The problem is that I don't know Orders.OrderID for the record I just inserted. It is not refreshed after the TableUpdate on the local cursor, and in this case, I have not any possible candidate key to try to retrieve it.
>
>Any ideas are appreciated,

Are you saying that REQUERY() doesn't work? Haven't done much with CAs, so I'd be disappointed if this wasn't the case.