I have a Product table.
The primary key is the Product ID and Color ID. The same Product ID is available in multiple colors.
Some Products dont have a Color, but I can not update the record without entering something in the Color ID.
I have tried space , but it does not accept it.
Is there anyway I can have the Color ID as part of the Primary key even though in same cases it is blank/null?
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (1)|