Re: primary key
From: Tom Ellison (tellison_at_jcdoyle.com)
Date: 09/09/04
- Next message: Lynn Trapp: "Re: primary key"
- Previous message: Quizarate: "Sub Query Consolidation, Syntax Question"
- In reply to: Kay: "primary key"
- Next in thread: Kay: "Re: primary key"
- Reply: Kay: "Re: primary key"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 09 Sep 2004 11:35:11 -0500
Dear Kay:
To make a column to be part of a primary key, it must have Required =
Yes (for Jet). Before you can do this, you may need to make sure
there are no NULLs in that column. Otherwise, it won't allow you to
set Required = Yes for that column.
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
On Thu, 9 Sep 2004 08:46:07 -0700, "Kay" <kwickham@stecoinc.com>
wrote:
>When I try to make a field the primary key and save it, it
>tells me that I can not make a field with a "null" value
>the primary key. It says that on all of the fields I have
>tried. So, how do I make a field not be of a "null" value
>so that I can make it a primary key, which I am trying to
>do so I can keep from haveing duplicate records in a
>query.
>
>Thanks, Kay
- Next message: Lynn Trapp: "Re: primary key"
- Previous message: Quizarate: "Sub Query Consolidation, Syntax Question"
- In reply to: Kay: "primary key"
- Next in thread: Kay: "Re: primary key"
- Reply: Kay: "Re: primary key"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
