How do I turn off "auto numbering" on the "Asset ID" field in the.

G

Guest

I need an Asset Tracking program for work. The Asset Tacking Template that
comes with Access is perfect for what I need except the "Asset ID" field is
set to "auto number".

I need to be able to put my own asset ID numbers in that field. I tried to
set that field as a "Number" field but a window pops up and says that I can't
change the data type or field size because it's part of a relationship. What
do I do?
 
D

Douglas J. Steele

Go into the Relationships window (Tools | Relationships) and delete any
relationships linked to the table through the Asset ID field. (Make sure you
note what relationships you're deleting, because you'll have to recreate
them later!) Make the change to your table, then recreate the relationships.
 
L

Luiz Cláudio

You have to set you data type as Number - Long Integer, which is compatible
(in size) to autonumber.

If you have any problem with the relationship, delete it, change the data
type and recreate the relationship (do not forget to enforce referential
integrity).

Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 

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

Populate a Field 3
color of field in each record of datasheet depends on other field 1
Asset Template in Access 3
Changing Primary Key numbering format 1
How to get query results that depend on the same query on anotherrecordset 7
Asset Tracking Template 1
Manually assign unique numbers in the asset id field box 2
Asset ID 1

Top