Contact Exists for Relation

Gary · Mar 22, 2004

I have two tables. Contacts and Notes. If there is a
relationship between the ID fields in both tables, how
can i reference them in code so I can bind two data grids?

My ultimate goal is to populate the first datagrid with
Contacts. When the user clicks on a row, then the second
grid should contain the notes related to the record on
the first grid.

I have asked a question earlier today regarding this, but
so far nobody has answered and I am really stumped.

Thanks,

Gary

Cor · Mar 23, 2004

Hi Gary,

There are a lot of samples on MSDN for this and also in the resource kit.

How to build a Master Detail it is always called

http://msdn.microsoft.com/library/d...lkthroughcreatingmaster-detailwindowsform.asp

Another and in my opinion nicer approach is filling the dataset everytime in
a seperate dataset.

This gives the most up to date data, while your second dataset is smaller.

I hope this helps,

Cor