Re: [MS_AccessPros] Re: How to enter different product in the same carton

 

Khalid-

You will need to initialize CartonSuffix by running an Update query.

UPDATE MyTable

SET CartonSuffix = 0

WHERE CartonSuffix IS NULL

John

Sent from my iPad

On Oct 19, 2014, at 11:32, khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

While selecting both fields CartonNo and cartonSuffix by holding down the shift and then clicking on Primary key both fields become Primary key, but while saving the table i get an error message "Index or Primary key cannot contain a null value".

I am also not getting replies in my yahoo inbox, i am replying you from the group.

Khalid

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___