(Newbie) Problems configuring tables relationships in a DataSet.xsd

microsoft.public.dotnet.framework.adonet

22 Feb 2007 8:33 PM

marivi

Hi!
I'm having some problems when configuring table relations in my
DataSet.xsd file.
I'm trying to do that through the Design Editor, openning DataSet.xsd.
What I want is to have the same configuration as in the SQLServer DB
it is referrering to.

What I try is to change "Relation Only" to "Both Relation and Foreign
Key Constraint": is this a good method? I have a medium sized DB and
this process is too long ...

No matter, I have time enough to change each relation :), everything
goes ok till I try to change the relation between tables shown below,
as example.

I show 5 tables, to show how their keys are related, but the important
relation is the one between Table4 and Table5.

If the relations aren't configured at all, the DS works fine, but if
this precise relation (4 fk, and only 1 relation) is configured, then
the DS is corrupted, and the following error is shown:
"Parent Columns and Child Columns don't have type-matching columns".

Can anybody help me? Really appreciate your help!

Sorry: the post is too long! (And my horrible-English .... sorry
again!)

Table1
--------------------
id_tb1
-------
any other fields

Table2
--------------------
id_tb1 (fk)
id_tb20 (fk)
-------
any other fields

Table3
--------------------
id_tb1 (fk)
id_tb20 (fk)
id_tb3 (fk)
id_tb4
-------
any other fields

Table5
--------------------
id_tb1 (fk)
id_tb20 (fk)
id_tb3 (fk)
id_tb4 (fk)
-------
any other fields