How do I do a master-detail on the same table?

[William Buchanan]

Hi folks

I have a datagridview which shows 2 fields from a table using a tableadapter
/ bindingsource. When I select a record, I want to see the remaining fields
in data bound controls at the bottom of the form. How do I do that?

I have found lots of postings showing how Master/detail works, but it does
not apply in this case since the record being shown is the same as the
selected one.

Thanks

Will

 

[William Buchanan]

Errrr, don't worry about this one. I had tried binding the text boxes to the
same binding source previously and it hadn't worked... I realised that I was
changing the master data source at runtime but forgot to do the same for the
text boxes!!