Changed Autonum to Number, Now Can't Enter Field

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

Guest

I used the Access wizard to create a service call database. The CustomerID
defaults to Autonum but I want to be able to type this number in so I changed
the properties. Now, I can't enter that box on the Workorder By Customer
Form. What did I do wrong?
 
You did nothing wrong. When you create a table its a good idea to have a
primary key which is a unique number for each record. So this way there are
not duplicate records. Autonumber is the normal way to make sure each record
is unique. The wizard made CustomerID your primary key field so you can do a
few things to fix this. You could leave it alone and make a new field you
can change or you can go into the table properties and change its type from
auto to number. But if you do this and it is your primary key then each
number you type in needs to be unique. Now this isn't a bad thing but if
there is a mistake then error will happen.
I have to go now, i can talk more tomorrow.
Good luck!
 
Back
Top