Index or primary key cannot contain a Null value

Please help....Thank you

hi,

Desperate wrote:
Please help....Thank you
You have left some fields of a recordset empty, thus it will be filled
with NULL (the non-value).
The field(s) forming the primary key must be filled with values.
If the fields are in an index you may modify the index to allow NULL.

You have to take a look at the involved table. The fields marked with
the key symbol are the primary key. Indices are modified in the Index
window.


mfG
-- stefan --

On Mon, 5 Jan 2009 23:01:01 -0800, Desperate
wrote:

Please help....Thank you


You're trying to create a Primary Key on a table.
At least one record in the table has a NULL (empty, nothing defined) value in
the field which you wish to become the primary key.
A Primary Key cannot have any records with a NULL.

Correct the data in your table so that none of the records contain a NULL
value in the primary key field (or any of the fields, if you're using a
multifield primary key) and then create the index.
--

John W. Vinson [MVP]