link two datagridviews?



hi,

i have two tables, related by a one to many relationship. i want a form with
both tables showing, and when i click on a record in the 'one' datagridview,
i want the 'many' view to show only the related records.

also...i want to be able to see all the records in the 'many' view when i
want.
and...i want both the 'one' and 'many' views to have navigation menu strip.

i've been searching around and have created a relation between the two table
adapters, but am not sure how to make the form behave the way i want? i
would think this could be pretty automatic, so i am holding off writing code
for click events until i hear if there is a better way.

thanks!

Fred


.