Does anyone have any links explaining how parent/child tables can be displayed/modified, with the parent table fields being bound to text boxes, while the child table is bound to a datagrid?
I'm using VB.NET to code, and SQL server 2000 as DB. I've got a parent table "Offices", and a child table "Departments". In my main form, i've got a datagrid that's bound only to the "Offices" table. When i click on a "Details" button, a dialog form pops up with the fields from the "Offices" table in text boxes (of the selected record in the datagrid on the main form), and the feilds from the "Departments" table on a datagrid just below it.
I want to be able to add/delete/edit the rows in the "departments" table from this form.
Appreciate any help. CV.