Linking DataSets

microsoft.public.dotnet.framework.adonet

9 Dec 2004 7:02 PM

MplsCpl

I'm going to try to be as succinct as possible when asking this
question, so bear with me.

Let's say I have two tables in a DB: 'salespeople ' and 'contacts'.
'salespeople' has a primary key field "id", which is the foreign key to
'contacts', which is the table that lists all contacts of the
salespeople. To be brief, here's a pseudo-schema:

table salespeople:
int id
....

table contacts:
int contactId,
int salesId (a froeign key to the 'salespeople' table
....

My question is, can I create two DataSets from a DataAdapter and when
the position of the 'salespeople' table is advanced, the data in the
'contacts' table is automatically refreshed to reflect only the
contacts which are associated with the current salesId from the
'salespeople' table?

The point being I want the 'contacts' table in the dataset to reflect
only the contacts that are related to the current salesperson, as
indicated by the current record in the 'salespeople' table.
Mike
---
http://hole19.compurhythms.com