G
Guest
I have 4 tables. In each of them I am using a field called Membership No as
the primary key. In 3 tables it works just fine. But in one, whenever I try
to set the primary key, the message comes up "index or primary key cannot
contain a null value". The membership numbers are 8 figures long, starting
with 2 zeroes - eg 00123456. As I had already entered most of the numbers
before setting the primary key (as with the other tables) I even deleted the
figures and re-entered them. It drives me crazy when something works for one
table and yet won´t work for another! I´m using Office 2003. Help!
the primary key. In 3 tables it works just fine. But in one, whenever I try
to set the primary key, the message comes up "index or primary key cannot
contain a null value". The membership numbers are 8 figures long, starting
with 2 zeroes - eg 00123456. As I had already entered most of the numbers
before setting the primary key (as with the other tables) I even deleted the
figures and re-entered them. It drives me crazy when something works for one
table and yet won´t work for another! I´m using Office 2003. Help!