Just a problem

[Zvonko]

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?

Hi, you can use queries to retrieve particular fields from ur tables. something like "Select fieldname from tablename". You can use this to refer to the data in the field.
If you have got a specific problem, dont hesitate to mail me. All the best...vijay

[Edited by gantibabu on 10-21-2000 at 02:00 AM]

[monte96]

If your using access, nope. You need a recordset. If your using SQL Server, you can put your update/insert into a stored proc and pass back the new ID as a output paramter/return value.