When entering data in a form, the value in my primary key changes

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

Guest

This is my first database.

My primary key that links the table is a number.

When I am entering data, the primary key field changes to "0".

I changed the properties of the primary key to no default, but I still have
this problem.

Any help would be appreciated.
thanks.
 
Hi Donna,

For your immediate needs, go into your table design, and change the datatype
from "number" to "Autonumber". This will solve your default value issue.

Brian
 
Back
Top