Page 2 of 2

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Thu Aug 19, 2010 1:16 am
by Marcel
Hi,

those relationships are in the data, meaning that Product is inside CommercieelProduct. Stimulsoft Designer place these relationship. I cannot influence those relationships, or can i?

I have created a stripped down mrt file. So, for example Collo is not in the mrt file anymore.

However, I still have the same problem.

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Thu Aug 19, 2010 6:31 am
by Alex K.
Hello,

When ADO reads XML into a DataSet, it creates DataTables to contain each type of element it encounters. Each table is uniquely identified by its name.
Also, a given table can have any number of parent tables, but only one of its parent relations can be nested - otherwise, a given record would get written to the XML multiple times, as a child of each of its parent rows.

In your report next relations:
Code -> Product (Code.Product_ID = Product.Product_ID) -> Code (Product.Product_ID = Code.Product_ID)
These relations and issue an error message.

Thank you.