ACC2002: Lookup Field Is Not Updated When You Change the Lookup Display Column in a View (282372)

The information in this article applies to:

Microsoft Access 2002

This article was previously published under Q282372

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

When you change the ProductName field in the Order Details Extended view to a different value, the ProductName field is properly updated to the new value. However, the ProductID is still the product identification number for the original product name and not the corresponding ProductID for the new product name.

CAUSE

The extended properties that are needed to properly look up and change the corresponding ProductID field to a new value were not created.

RESOLUTION

Copy the SQL code of the Order Details Extended view into a new view. You can then modify the product name using the lookup in the ProductID field.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce the Behavior:

Open the sample project NorthwindCS.adp connected to Microsoft SQL Server 2000.
Open the Order Details Extended view.
For order number 10248, change the product name from Chai to Tofu. Press the down arrow to commit the row. Note that the other rows that previously had Chai as a product name now have a product name of Tofu. However, note that the ProductID is still the product identification number for Chai (1) and not for Tofu (14).

Modification Type:	Major	Last Reviewed:	9/27/2003
Keywords:	kbprb KB282372