help - Index or Primary Key Cannot Have A Null Value

[janeyg]

Hi, I am new to this forum nd have alot of help here but I can't seem to get to the bottom of this Index or Primary Key Cannot Have A Null Value with one particular table. I remove the primary key, it still pops up. I have removed default values, all with no joy. I have a few look up fields but removing these did not seem to work either. I am totally at a loss. I want to split my database now but because of this error, I can't.

Can anyone help me please?
thanks in advance.
Janeyg

 

[pr2-eugin]

It means that the Field which is declared as Primary Key in the table has a row(s) that have NULL value in it. So instead of removing the Primary Key, check the values and see if it NULL and update them accordingly.

 

[janeyg]

I have scrolled down my table and checked the rows and I have data in each, non are null?

 

[janeyg]

Also, my primary key field is an auto number. Do you think it could be the indexes? am not sure what to check here. I have another field indexed) set to Yes, no duplicates.

Any help would be appreciated.
thanks

 

[RainLover]

I have scrolled down my table and checked the rows and I have data in each, non are null?

This proves nothing. Because you are getting an error the record is not saving, Therefor no Nulls.

Something is wrong in the Table. One would think.

Open the Table directly. Slowly add data to find which fields are required or not.

You should be able to work it out from there.

 

[janeyg]

Thanks for your help Rain, I got it!

 

[RainLover]

Glad you got it.

 

[pensize599]

Something is wrong in the Table. One would think.