PRB: Cannot Enter Product Relationships with the Same Name in Business Desk (294233)


The information in this article applies to:

  • Microsoft Commerce Server 2000
This article was previously published under Q294233

SYMPTOMS

When you use the Commerce Server Business Desk, you cannot create multiple product relationships with the same name. For example, when a specific SKU has more than one substitute SKU, and the customer wants to name each relationship "substitute."

CAUSE

The Business Desk UI prevents these relationships from being created; however, the Catalog API (more specifically, Product.AddRelationshipToProduct) allows duplicate relationship names in a single product.

RESOLUTION

To work around this problem, use the following steps:
  1. Open the following file in Notepad (or any ASP editor):

    RetailBizdesk\Catalogs\Editor\Edit_product.asp

  2. Locate the following line:

    <global keycol='rel_name' uniquekey='yes' sortbykey='no' />

  3. Change the uniquekey value from yes to no.
  4. Save the change, and then reload the Business Desk.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Commerce Server 2000.
Modification Type:MajorLast Reviewed:10/21/2002
Keywords:kbprb KB294233
©2002 Microsoft Corporation. All rights reserved.