automatically assign a unique number to a record when saved

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I will have 3 HOTLINE users at 3 different cubicles running duplicate DB
front ends connected to a back-end DB. I would like the DB to automatically
assign a unique record number as each person saves a record (HOTLINE CALL).
Any suggestions appreciated!
 
The table already has an autonumber field (index). Are you suggesting a
second autonumber field?
 
No. You state that you want "the DB to automatically assign a unique record
number as each person saves a record." That is what the autonumber field
does. Does the number in that field not meet your needs for some reason?

Rick B
 
If your "index" is the table's Primary Key, you already have a unique record
identifier. That's what a primary key is.

HTH
Sprinks
 
As mentioned in another post earlier today to someone, you can use the
'format' option to establish how the number displays in Forms, Reports, and
Queries. This would allow "1" to display as "0001".

Rick B
 
OK... You gave me some ideas! I wanted the unique numbers to start at 1000 so
I added an unbound control to the form to sum 1000+[CallLogID] to display a
four digit number to satisfy the user. For reports created from a query, I
created an expression in the query that does the same thing. Seems like brute
force but it works. I would guess there are better ways to do it!
 
You would have to do some searches, but I have seen posts on here before
that explain how to start your auto-number at a particular point.

Rick B

Dan said:
OK... You gave me some ideas! I wanted the unique numbers to start at 1000 so
I added an unbound control to the form to sum 1000+[CallLogID] to display a
four digit number to satisfy the user. For reports created from a query, I
created an expression in the query that does the same thing. Seems like brute
force but it works. I would guess there are better ways to do it!


Rick B said:
As mentioned in another post earlier today to someone, you can use the
'format' option to establish how the number displays in Forms, Reports, and
Queries. This would allow "1" to display as "0001".

Rick B



unique
record suggesting
a
Click to expand...
Click to expand...
 
Back
Top