editing XML relationship lines

[Charlie Brookhart]

I am working on a program where I am retrieving data from an Access database
through one common dataset. I have already put the database connection
component on the form as well as the two data adapters. Here is where I am
having problems. I double click on the .xsd file and then go to the schema
menu and select add|new relationship. My table names are Employee and
Payroll. Employee ID is a primary key in the Employee table and a foreign
key in the Payroll table. I need to define a DataRelation link with Employee
ID. The problem is that when the parent table is set to Employee and the
child table is set to Payroll, the "OK" button in the xml editor becomes
greyed out. If I change the child table to employee, then I can click OK. I
did this, but now I have the relation line drawn on the left side of the
employee table coming from the primary key. When I go to debug, I have a
list of 5 build errors. In the programming book I am working from, the
example shows selecting the second table for the child table, so it would
seem that I am following the correct steps, but something isn't working
right.

Questions:
Why is the "OK" button greyed out when I select payroll as the child table?
How do I fix the existing relation line?

[Cor Ligthert [MVP]]

Re: editing XML relationship lines

Charlie,

The change that somebody in this newsgroup is working with this feature (XML
dataset designer) is low.

You have probably more change in the newsgroup.

microsoft.publi c.dotnet.framew ork.adonet

Not to kick you out you are most welcome here.

Cor

"Charlie Brookhart" <charliebrookha rt46@hotmail.co m> schreef in bericht
news:y9Odnal0TN 3FA__ZnZ2dnUVZ_ tSdnZ2d@adelphi a.com...[color=blue]
>I am working on a program where I am retrieving data from an Access
>database
> through one common dataset. I have already put the database connection
> component on the form as well as the two data adapters. Here is where I am
> having problems. I double click on the .xsd file and then go to the schema
> menu and select add|new relationship. My table names are Employee and
> Payroll. Employee ID is a primary key in the Employee table and a foreign
> key in the Payroll table. I need to define a DataRelation link with
> Employee
> ID. The problem is that when the parent table is set to Employee and the
> child table is set to Payroll, the "OK" button in the xml editor becomes
> greyed out. If I change the child table to employee, then I can click OK.
> I
> did this, but now I have the relation line drawn on the left side of the
> employee table coming from the primary key. When I go to debug, I have a
> list of 5 build errors. In the programming book I am working from, the
> example shows selecting the second table for the child table, so it would
> seem that I am following the correct steps, but something isn't working
> right.
>
> Questions:
> Why is the "OK" button greyed out when I select payroll as the child
> table?
> How do I fix the existing relation line?
>
>[/color]

[Charlie Brookhart]

Re: editing XML relationship lines

I have posted this message in the dotnet.framewor k.adonet group and in the
microsoft.publi c.dotnet.xml groups, but have not received any replies.

I would really like to get some help in resolving the problem that I am
having so that I can finish the program I am working on and start the next
one.

"Cor Ligthert [MVP]" <notmyfirstname @planet.nl> wrote in message
news:%23oIIg%23 MdGHA.5016@TK2M SFTNGP04.phx.gb l...[color=blue]
> Charlie,
>
> The change that somebody in this newsgroup is working with this feature[/color]
(XML[color=blue]
> dataset designer) is low.
>
> You have probably more change in the newsgroup.
>
> microsoft.publi c.dotnet.framew ork.adonet
>
> Not to kick you out you are most welcome here.
>
> Cor
>
> "Charlie Brookhart" <charliebrookha rt46@hotmail.co m> schreef in bericht
> news:y9Odnal0TN 3FA__ZnZ2dnUVZ_ tSdnZ2d@adelphi a.com...[color=green]
> >I am working on a program where I am retrieving data from an Access
> >database
> > through one common dataset. I have already put the database connection
> > component on the form as well as the two data adapters. Here is where I[/color][/color]
am[color=blue][color=green]
> > having problems. I double click on the .xsd file and then go to the[/color][/color]
schema[color=blue][color=green]
> > menu and select add|new relationship. My table names are Employee and
> > Payroll. Employee ID is a primary key in the Employee table and a[/color][/color]
foreign[color=blue][color=green]
> > key in the Payroll table. I need to define a DataRelation link with
> > Employee
> > ID. The problem is that when the parent table is set to Employee and the
> > child table is set to Payroll, the "OK" button in the xml editor becomes
> > greyed out. If I change the child table to employee, then I can click[/color][/color]
OK.[color=blue][color=green]
> > I
> > did this, but now I have the relation line drawn on the left side of the
> > employee table coming from the primary key. When I go to debug, I have a
> > list of 5 build errors. In the programming book I am working from, the
> > example shows selecting the second table for the child table, so it[/color][/color]
would[color=blue][color=green]
> > seem that I am following the correct steps, but something isn't working
> > right.
> >
> > Questions:
> > Why is the "OK" button greyed out when I select payroll as the child
> > table?
> > How do I fix the existing relation line?
> >
> >[/color]
>
>[/color]