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? 2 976
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.public.dotnet.framework.adonet
Not to kick you out you are most welcome here.
Cor
"Charlie Brookhart" <ch****************@hotmail.com> schreef in bericht
news:y9******************************@adelphia.com ... 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?
I have posted this message in the dotnet.framework.adonet group and in the
microsoft.public.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]" <no************@planet.nl> wrote in message
news:%2******************@TK2MSFTNGP04.phx.gbl... 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.public.dotnet.framework.adonet
Not to kick you out you are most welcome here.
Cor
"Charlie Brookhart" <ch****************@hotmail.com> schreef in bericht news:y9******************************@adelphia.com ...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?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dan Weeb |
last post by:
Hi All,
I have struggled through this far with help from many of you so thanks. I am
stuck again. I am really new to this so don't be harsh :-)
There are a few problems. You can run the script...
|
by: Sukkel |
last post by:
When I define relations in the Backend of my Database, everything works
fine. I get these funny lines (with 1 and "OO") between the fields of
the different table that indicate a one to many...
|
by: musosdev |
last post by:
Hi guys
I've got the following error on a project which is running locally on a
vs2005 machine (built in webserver), trying to connect to my win2k3 server
active directory.
the error is...
...
|
by: ritesh |
last post by:
Hi,
I'm facing a problem in which I need to edit an already created file,
and the editing needs to be done at the start of the file rather then
appending to the file.
OS - Linux,Solaris
...
|
by: Leventcos21 |
last post by:
Hi all, I have been stuck on this issue for weeks now and can not find a solution, so I hoping that someone can help me out.
I am setting up a training database. I have setup the structure and...
|
by: access baby |
last post by:
I have 5 tables need to create relationship
Customer Table
CustomerID(auto number)(primary key)
Customer Name(text)
Customer City(text)
Customer St(txt)
Customer OrderTable
Customer...
|
by: kirby.urner |
last post by:
There's been some chatter on edu-sig (python.org) of late regarding
Python's
capabilities in the "edit/continue" tradition, meaning debugging
tools, and/or
IDE tools, that give the developer real...
|
by: cjakeman |
last post by:
Hi,
Solved a little mystery yesterday when I built a form that combined 2
tables with a 1:M relationship and relational integrity. All the
correct data was visible on the form but, if I tried to...
|
by: Richard |
last post by:
Hi folks, thanks for taking the time to read this (and hopefully point
our where I'm going wrong).
The scenario:
I have a local Access2007 database which links in several read only
mySql...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |