Unique serial neumber in table

U

User

I would like each new record that is entered into a table to have a unique
seial number automatically assingned to that row of data. Is it possible to
do that?
 
K

Klatuu

It may be an Autonumber field type which is a Long Integer data type, but be
aware it is not a number you can control and it may not always be incremented
without gaps. Autonumber fields should really only be used for primary keys
which are then used for relating records in master/child tables. The should
have no meaning in an application. If you need a serial numbering system
that will have meaning to the user or business, then you need to establish
your own numbering system to meet the business requirements.

If you need help with this, post back with the business rules of the
numbering system and I am sure we can assist with that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Copy previous record into form field 0
Appending tables 0
VBA - exporting serial letters to single documents 0
Creating a printable raffle ticket with serial numbers 0
Finding the right style field in VBA 0
Nested IIF for Hierachy 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top