Rick,

I was just going through these lessons again as reenforcement learning and have a question about SQL versus Recordsets.  If we use SQL for creating a new PO, can we still get the assigned autonumber or is that only available during the recordset sequence?  The insert into statement seems to process the addtion without a chance to grab onto the newly assigned ID right?

---

Reply from Richard Rost:

SQL will not give the ID. You'd need a recordset for that. You could use SQL, then immediately use DMAX to get the ID, but that's less reliable, especially in a multi-user environment.