John,
After running the update query "qryCartonSuffixUpdate"
UPDATE CollectionVoucher SET CollectionVoucher.CartonSuffix = 0
WHERE (((CollectionVoucher.CartonSuffix) Is Null));
Now again after defining CartonNo and CartonSuffix as Primary key and saving the table i get the error message "The changes you requested to the table were not successful because they would create duplicate values in the indes, Primary key, or relationship. Change the data in the field............"
Khalid
__._,_.___
Posted by: khalidtanweerburrah@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar