MOD2000: Workflow Process Wizard May Display Incorrect Lookup Keywords

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.

Back to the top