primary key

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kay (kwickham_at_stecoinc.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 08:46:07 -0700

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

Relevant Pages

  • Re: Problem with Access concatenate query
    ... records in the final query. ... You probably need to INNER JOIN the tables, although on what column, I am not sure. ... PriceID -- Primary Key ... ItemID --- Foreign Key ...
    (microsoft.public.access.queries)
  • RE: Processing thousands of records
    ... Jerry Whittle, Microsoft Access MVP ... Access automatically creates an index for primary key fields. ... that the query is working faster, you don't need the 1stVisit02 query. ... where do I read about fundamental indexing and normalization? ...
    (microsoft.public.access.queries)
  • RE: Processing thousands of records
    ... Access automatically creates an index for primary key fields. ... that the query is working faster, you don't need the 1stVisit02 query. ... Jerry Whittle, Microsoft Access MVP ... where do I read about fundamental indexing and normalization? ...
    (microsoft.public.access.queries)
  • Re: Determining if a form has a table or query recordset source
    ... how to obtain the primary key of a query? ... the generic answer is: "who says any query has one?". ... > set for insertion into an audit trail table, ... > Dim audID As Long ...
    (microsoft.public.access.security)
  • Re: [PHP] peer review (was php framework vs just php?)
    ... those POST/GET elements, the global elements and the development of the sql ... generation of a SELECT query ... html with embedded php variables ... //get the primary key for the table ...
    (php.general)