How do I set numbers as primary keys?

Question

I do understand that a primary key must be unique, but i'm having a difficult time trying to input numbers as primary keys, and connect them with other tables. Do i need to do the relationship builder first; what can I do ? By the way, I'm a new user of Access 2007, and this is for a database project; very simple. If anyone can help me i'll appreciate it.

Update:

serious answers please..

Update 2:

I'm doing a simple database that tracks fitness goals, and measurements.

Anonymous · Accepted Answer

If you do not assign the primary key it will ask you, use autonumber when using Primary keys...
When your tables are built, and a relationship is made using those primary keys your data is ready to go

If you already have your primary key, change the datatype to autonumber and make sure that your Indexed field on the general tab is set to
Yes (No Duplicates)

Dakid · Answer

First, Which database are you using? Use should not assign primary keys by hand because you do not want to make a mistake and assign the same primary key to two entities. Most database have an autonumber that you can assign.

? · Answer

Ans #3 is about right on time... I would add this:

If the numeric key that you want to use is not serial, that is to say that it is based on some external source to your DB, setting the field to auto number will cause you grief...  you might then need to use the relation manager to control ads updates and deletes to related tables

Anonymous · Answer

http://office.microsoft.com/training/training.aspx?AssetID=RC102864461033

http://office.microsoft.com/training/training.aspx?AssetID=RC102917861033

Trending News

How do I set numbers as primary keys?

4 Answers