data diagrams, dataset, please help
- From: "Michelle" <nospam_mbytwo-news@xxxxxxxxxxxx>
- Date: Wed, 5 Apr 2006 07:59:59 +1000
Hi all (Using VS 2005, vb.net)
Ok, I might be missing something *HUGE*, so please excuse me, I'm starting
to get a little desperate to understand this now. My confusion is about
multiple tables - master/detail in particular.
Some background: 2 tables, master/detail: CUSTOMERS [1 to many relationship]
to ORDERS.
When I add a new datasource and the resulting dataset, I have both tables
separately appear under my dataset view (so far, I understand this).
I have also created a data diagram that links CUSTOMERS to ORDERS (as in the
above relationship)
This is where I'm confused:
When I expand the CUSTOMERS table, I also have the ORDERS table appear again
directly underneath the last field of CUSTOMERS table (obviously because of
my data diagram relationship).
Q1: If I have a master/detail relationship as I have just described, is it
necessary to create a data diagram? If not, how do I directly reference a
new record being added into ORDERS and have the Foreign Key (FK) be added
automatically? <-- Do i need to do this manually??
Q2: When I'm referencing the dataset, do I reference the ORDERS table that
appears part of the CUSTOMERS table or the *separate* ORDERS table that
appears?
Appreciate any help / link provided.
Cheers
.
- Prev by Date: Re: Store procedure vs Direct statement ???
- Next by Date: query builder and derived table
- Previous by thread: The TableAdapter update command is not identical
- Next by thread: query builder and derived table
- Index(es):
Relevant Pages
|
