how do i define a primary autonumbering field in design view

  • Thread starter Thread starter Linda
  • Start date Start date
Unless you are talking about doing this with code, I sense a homework
question written in only moderately obscure teacherese. In normal language,
it means open a table in Design View (click the Design button), type the
name of your field in the Field Name column. In the Datatype column, choose
AutoNumber. While you are still on that row, click the Primary Key button on
the toolbar (looks like a Yale key). A Key symbol will appear next to the
field name showing that this field is the Primary Key field of your table.
Evi
 

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

Data Primary key vs. Artificial (Autonumber) primary key 78
AutoNumber vs. Natural Primary Keys 6
Multi-Field Primary Key 19
Primary Key Autonumbers 23
Defining Relationships/Primary Keys between two tables 3
Change primary key from autonumber to text field? 1
Do I need a sequential primary key? 7
Table Design 3

Back
Top