Autonumber not updating fast enough

[dfedosoff]

I was reading in your forums and found out that SQL does not add an autonumber field until it saved. I have an ACCESS front end database that I use this autonumber to create the MERGEID which is my primary key and key cluster. I need SQL to populate the AUTONUMBER field right away so my VB script can create this MERGEID.

How can I get this done?

Diana

[ck9663]

Depends on how your front-end steps goes through. I would recommend you lawt your front-end goes through then after all the input is done, save the data on your form and display everything again with the MERGEID displayed.


--- CK