Unique serial neumber in table

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

Guest

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?
 
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

Two separate tables in Access I need to match the data using a Pke 2
Access Autonumber NOT Unique 6
Entering data in a field enters the same data in other forms/field 2
Nested IIF for Hierachy 1
Table Relationships 2
Turning Data into a Table 1
Turning a 3 column flat file into a "3D" Table 2
Assign unique numbers for each... 5

Back
Top