OFFXPDEV: Add Detail Table Dialog Box Opens but You Cannot Select a Table (287722)


The information in this article applies to:

  • Microsoft Office XP Developer
This article was previously published under Q287722

SYMPTOMS

If you try to add a Detail table to your Workflow Designer for SQL Server solution, the Add Detail Table dialog box will open even though you see the error message:
No vaild parent tables could be found in the chosen database.
However, you cannot select any table in the dialog box because the drop-down lists are empty.

NOTE: The word "vaild" in the error message is a misspelling of the word "valid."

RESOLUTION

You must add a Main table to your project before you can add a Detail table. If the Add Detail Table dialog box is open, click Cancel to close it.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the Microsoft Development Environment.
  2. On the File menu, point to New, and then click Project.
  3. Click SQL Server Workflow Project in the New Project dialog box, and then click OK.
  4. When the Create a New SQL Server Workflow Project dialog box opens, choose your local server, select Northwind as the database, and then click OK.
  5. Click your project in the Solutions Explorer, and then on the Project menu, click Add New Item.
  6. When the Add New Item dialog box opens, click Add a Detail Table in the Templates list, and then click Open.

    Note that you receive the following error:
    No vaild parent tables could be found in the chosen database.
  7. Click OK to close the error message. Note that the Add Detail Table dialog box still opens.
Modification Type:MajorLast Reviewed:10/29/2001
Keywords:kbbug kberrmsg KB287722
©2002 Microsoft Corporation. All rights reserved.