Microsoft KB Archive/253379

Knowledge Base

MOD2000: Workflow Process Wizard May Display Incorrect Lookup Keywords

Article ID: 253379

Article Last Modified on 9/3/2002

---

APPLIES TO

• Microsoft Office 2000 Developer Edition

---

This article was previously published under Q253379

SYMPTOMS

In the Workflow Process Wizard of Access Workflow Designer, if you move back and change the Keyword column value, the next step in the process may display incorrect lookup keywords.

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Developer Service Release 1 (SR-1).

To obtain SR-1, click the article number below to view the article in the Microsoft Knowledge Base:

253566 MOD2000: How to Obtain and Install Microsoft Office 2000 Developer Service Release 1 (SR-1)

To temporarily work around this problem, quit the Workflow Process Wizard, and then restart it.

STATUS

Microsoft has confirmed that this is a problem in Office 2000 Developer.  This problem was corrected in Microsoft Office 2000 Developer SR-1.

MORE INFORMATION

Steps to Reproduce the Behavior

1. Create a SQL database with multiple lookup columns. Follow these steps to create the necessary tables:
   1. Open SQL Server Query Analyzer.

   2. Enter the following script:

      use master
      go
      create database MultiplePredefinedLookups
      go
      use MultiplePredefinedLookups
      go
      CREATE TABLE dbo.MainTable (
          id int NOT NULL IDENTITY (1, 1),
          data char(10) NULL,
          state int NULL) ON [PRIMARY]
      go
      ALTER TABLE MainTable ADD CONSTRAINT
          PK_MainTable PRIMARY KEY NONCLUSTERED (id) ON [PRIMARY]
      go
      CREATE TABLE stateLookup (
          id int NOT NULL IDENTITY (1, 1),
          StateName1 char(20) NULL,
          StateName2 char(10) NULL,
          StateName3 char(30) NULL,
          StateName4 varchar(128) NULL) ON [PRIMARY]
      go
      ALTER TABLE stateLookup ADD CONSTRAINT
          PK_stateLookup PRIMARY KEY NONCLUSTERED (id) ON [PRIMARY]
      go
      ALTER TABLE MainTable ADD CONSTRAINT
          FK_Status FOREIGN KEY (state) REFERENCES stateLookup(id)
      go
      insert into stateLookup (StateName1, StateName2, StateName3, StateName4) values ('SN1a', 'SN2a', 'SN3a', 'SN4a')
      insert into stateLookup (StateName1, StateName2, StateName3, StateName4) values ('SN1b', 'SN2b', 'SN3b', 'SN4b')
      insert into stateLookup (StateName1, StateName2, StateName3, StateName4) values ('SN1c', 'SN2c', 'SN3c', 'SN4c')
      insert into stateLookup (StateName1, StateName2, StateName3, StateName4) values ('SN1d', 'SN2d', 'SN3d', 'SN4d')
      insert into stateLookup (StateName1, StateName2, StateName3, StateName4) values ('SN1e', 'SN2e', 'SN3e', 'SN4e')
      go
                              

   3. Press F5 to run the script.
2. Start Access Workflow Designer.
3. Select the SQL Server, select the newly created database, MultiplePredefinedLookups, and then click OK.
4. In the Database Registration Wizard, click Next, accept the default registration entries, and then click Next.
5. Click OK to the Web creation question, and then click Finish.
6. In the Object list, right-click Tables, and then click Add Tables.
7. In the User Tables dialog box, click Main Table, click Next, and then click Finish.
8. In the Object list, right-click Workflow Process, and then click Add Workflow Process.
9. In the Workflow Process Wizard, click Next.
10. On the User Table page, click Next.
11. On the Workflow column page, click Use an existing column.
12. In the Workflow column list, click state.
13. In the Keyword column list, click StateName1.
14. Click Next and note the contents of the Lookup Keywords list box.
15. Click Back.
16. Change the selection of the Keyword column to StateName4, and then click Next.
    
    Note that the lookup keywords have not changed. The Lookup Keywords list box still displays the keywords associated with StateName1.

Additional query words: pra

Keywords: kbbug kbfix kbworkflowdesigner KB253379

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.