Autonumber of new record

[M Fisher]

Is there a way to get the autonumber of a newly inserted record?

I am working with unbound forms, and using an append query to insert a
record into a table. I am then using a select query that returns the max ID
(the autonumber field) of the table. This gives me the correct number.
However, could this go wrong in a multi-user environment. I insert a
record, and say it gets ID 10, but before (even thoug it is a split second)
I read the max value, someone else inserts a record with ID 11.

What I need is a way to get the nubmer of the record I have just inserted.

Thanks

[Philipp]

Hey!

I have an idea: Don't allocate the running number on form open-allocate the
running number on saving. You can do this with runningnumber = "select
max([Running Number]) from Table" + 1 (hope the syntax is correct). So you
have always the actual number. This also works in a network-client
database! I hope I help you - when you have problems, feel free to write!

Ps: Sorry for my bad english, I hope you know what I mean!

best wishes Philipp

Ok i think there is a way. When you write your record in the table, before
you
"M Fisher" <m.******@uku.c o.uk> schrieb im Newsbeitrag
news:xs******** *******@newsfe5-win.ntli.net...

Is there a way to get the autonumber of a newly inserted record?

I am working with unbound forms, and using an append query to insert a
record into a table. I am then using a select query that returns the max ID (the autonumber field) of the table. This gives me the correct number.
However, could this go wrong in a multi-user environment. I insert a
record, and say it gets ID 10, but before (even thoug it is a split second) I read the max value, someone else inserts a record with ID 11.

What I need is a way to get the nubmer of the record I have just inserted.

Thanks

[Arno R]

Indeed in a multi-user environment, the max value (autonumber ID) is not always *your* inserted record.

You will need an extra field UserID in YourTable. This will represent the person that inserted the record.
*Your* max value now is something like: Select Max(ID) FROM YourTable Where UserID = YourUserID

--
Hope this helps
Arno R

"M Fisher" <m.******@uku.c o.uk> schreef in bericht news:xs******** *******@newsfe5-win.ntli.net...

Is there a way to get the autonumber of a newly inserted record?

I am working with unbound forms, and using an append query to insert a
record into a table. I am then using a select query that returns the max ID
(the autonumber field) of the table. This gives me the correct number.
However, could this go wrong in a multi-user environment. I insert a
record, and say it gets ID 10, but before (even thoug it is a split second)
I read the max value, someone else inserts a record with ID 11.

What I need is a way to get the nubmer of the record I have just inserted.

Thanks