Hello!

I have kind an annoying problem .
The thing is that I have in my DB table field which is AutoNumber. And in that table I add another record. Is there any other way to retrieve that field's value without loading whole recordset, because I need that number for adding it to other records in some other tables that are referencing to just added record.
Any suggestions?