Hi, I hope someone can help!
I have a database that was working fine yesterday. I tired to enter in information into my form and today I am getting a pop up box that indicates I have a Index or primary key containing a null value. I have checked all of my tabels and relationships and I cannot seem to find this "null value" am I missing something? It seems I can enter in data into my table directly but not the form linked to that table.... I have looked and no relationship are broken... I am stumped. Thanks in advance.
M (IMG:style_emoticons/default/iconfused.gif)

This post has been edited by miedward: Feb 24 2012, 08:13 AM

Are you using a free text type field as your primary key where the user enters a value? If so, you should use an auto-id instead. This way the primary key is automatically entered once an entry is made in the record. If you're using that field because you do not want duplicates then you can just set it to not allow duplicates in the table by indexing it.