none
Error Message: Configure TableAdapter [table name] failed. Cannot find the parent relation "[relation name]". RRS feed

  • Question

  • Hi, I'm having the very same trouble as described below. Unfortunately, I haven't been able to find any solution / fix / workaround / ... for it.

    Best Regards,

    Honza

    ---------------------------------------

    Configure TableAdapter fails when using expression columns Hi,

    I’m having some problems with configuring a TableAdapter on a DataSet. The
    problem occurs when I have to related tables defined in a dataset
    (parent-child relation). If I add an expression column to the child table to
    map to a column in the parent and I try to configure the TableAdapter on the
    child table, I get an error message saying;

    Configure TableAdapter [table name] failed.
    Cannot find the parent relation ‘[relation name]’.

    To reproduce the behavior I’ll be using the Northwind database as an example.

    1. Create a new dataset and add two related tables from the Northwind
    database (e.g. by dragging ‘Orders’ and ‘Customers’ into the designer from
    the Server Explorer).
    2. Add a column to the child table ‘Orders’ and call it ‘expCustomerName’.
    3. Open the properties sheet for this column and set the ‘Expression’ field
    to ‘Parent(FK_Orders_Customers).CompanyName’. This will map the content of
    the column ‘Customers.CompanyName’ into the column ‘expCustomerName’.
    4. Right-click on the ‘OrdersTableAdapter’ in the DataTable ‘Orders’ and
    choose ‘Configure…’

    This will result in the following error message;

    Configure TableAdapter Orders failed.
    Cannot find the parent relation ‘FK_Orders_Customers’.

    --
    Sincerely,

    Kjetil Klaussen
    Application Developer, Trondheim

    Thursday, March 8, 2007 9:41 AM

All replies