>I'm not sure what you mean, didn't you have a requirement to know the primary key of the record you just created?

Yes, this has been resolved. It is now in the framework. So, if I need it, after and insert, it now looks like this:

loDataProvider.ParameterClear()
loDataProvider.ParameterAdd("NoMember", lnNoMember)
loDataProvider.ParameterAdd("IP", oApp.cIP)
If Not loDataProvider.SQLInsert("INSERT INTO AffiliateHit (NoMember,IP) VALUES (?,?)", oApp.aConnection(1)) Then
   Return False
End If

lnPrimaryKey=loDataProvider.nPrimaryKey