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
- Create a SQL database with multiple lookup columns. Follow these steps to create the necessary tables:
- Open SQL Server Query Analyzer.
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
- Press F5 to run the script.
- Start Access Workflow Designer.
- Select the SQL Server, select the newly created database, MultiplePredefinedLookups, and then click OK.
- In the Database Registration Wizard, click Next, accept the default registration entries, and then click Next.
- Click OK to the Web creation question, and then click Finish.
- In the Object list, right-click Tables, and then click Add Tables.
- In the User Tables dialog box, click Main Table, click Next, and then click Finish.
- In the Object list, right-click Workflow Process, and then click Add Workflow Process.
- In the Workflow Process Wizard, click Next.
- On the User Table page, click Next.
- On the Workflow column page, click Use an existing column.
- In the Workflow column list, click state.
- In the Keyword column list, click StateName1.
- Click Next and note the contents of the Lookup Keywords list box.
- Click Back.
- 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