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

What transaction IsolationLevel for?
Help: Login failed for User ???
Large Datasets
Sorting a Dataset table
IndexOutOfRangeException - Index was outside the bounds of the array.