What is the point of Relations?

[RDA]

So in VS 2008 I have created an XSD file with a master table and a
child table bound by a relation. I have bound the master table to a
datagridview. However, I have no clue how to access the child table
(yet have it relate to the master table via the relation).

So, in short, what is the point of Relations? How can I access them?
Common sense tells me it should be easy to create a "nested
datagridview" or something to display the child table within the
master datagridview, but this is not straightforward.

Please help!

 

[Miro]

It does like an automatic filter for you when you use the controls on a form
for example.

Are you looking for an example on how to display a master - detail using a
relation?

 

[RDA]

YES. Please.

 

[Cor Ligthert[MVP]]

Hi,

There is much more about relations and datagridview on this website, just
one

http://www.vb-tips.com/DatagridViewFormatting.aspx

Cor


YES. Please.

 

[Miro]

Think about this scenario

Lets say you have a master file and a detail file.
2 datagrids on a form.

You select * from master and select * from detail

in this scenario, if you have a relation, and the datagrids are setup to
link through the relation, as you select one record in the master, the
detail filters to be the records linked to the master.

Setting up the relation with "cacading updates and deletes" also delets the
child records for you
(providing they are loaded into your dataset).



YES. Please.