Primary Key

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

Guest

I have created a database for library books. We are just a small library
with so far about 3000 books. I have created a primary key called BookID and
set it to autonumber. We have many of the same books so I wanted them to
each be unique. What I want to be able to do is be able to do a book search
and have it show the primary key BookID # for easy of changing information
that was input into the database incorrectly. Is there a way to do this? I
already have a form created that is based on a query and will return the
books, author, category, Library, and notes when you type in a name of a
book. I just would like to add the one more field for displaying the primary
key. Thanks in advance.
 
I figured it out. After I typed it all out and sent it in my brain started
working. Thanks for looking!!
 
lilteddy78 said:
I have created a database for library books. We are just a small
library with so far about 3000 books. I have created a primary key
called BookID and set it to autonumber. We have many of the same
books so I wanted them to each be unique. What I want to be able to
do is be able to do a book search and have it show the primary key
BookID # for easy of changing information that was input into the
database incorrectly. Is there a way to do this? I already have a
form created that is based on a query and will return the books,
author, category, Library, and notes when you type in a name of a
book. I just would like to add the one more field for displaying the
primary key. Thanks in advance.
Click to expand...

Glad you figured it out. Just a note: Autonumbers do not always behave
as expected. They may skip numbers and things may "look" wrong. If this
would cause you problems you may have other options. It does cause many
users to think something is wrong.

Autonumbers should maintain unique numbers for each record however and
may serve you well.
 
Back
Top