On 29 Apr 2003 at 18:13, Helen Borrie wrote:

>access, you might as well do it the proper way - with a script.

Well... Setting to constant works in script. But what about this:

SET GENERATOR a_generator TO (SELECT max(ID)+1 FROM a_table)?

SY, Dimitry Sibiryakov.