Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Access primary key 1
- Thread starter Flyboy171
- Start date
-
1
- #2
You can make the key any size you want that is a valid Access data type/size (except memo or blob, I believe).
The PK doesn't necessarily need to be a single field either.
In your example, it looks like you want an alpha-numeric key that is (always?) 6 characters. You'd make a text type field, length of 6. Click the key icon and you're set.
How you assign the values is a different story.
--Jim
The PK doesn't necessarily need to be a single field either.
In your example, it looks like you want an alpha-numeric key that is (always?) 6 characters. You'd make a text type field, length of 6. Click the key icon and you're set.
How you assign the values is a different story.
--Jim
- Status
Similar threads
- Locked
- Question
- Locked
- Question