[RESOLVED] jmcilhinney Please help with my master/detail, dataadapter problems

[Nitesh]

JM it's done it even in the test project. Here's a rundown on how it works.

I select a product from the dropdown in the HeaderBindingNavigator. That brings up the records from the Result_Header table with a matching productid.

If I click on the master record in the master datagridview it brings up the child records in the child datagridview from the result_detail table.

I added a new record to the mater table, it's ID was 3. if a new row is added, I go check the prodtest table for test's that exist for that product. If tests do exist I add new datarows to the child table with the new resultid and the testid.

These added fine on the first save. I had two records in the child table with resultid(foreign key which is the id from result_header) 3. Then without closing the form I added record number 4 to the result_header datagridview.

I clicked save and it saved test3 again as record number 4 and then test4 as record number 5 in the parent table.

and in the child table 4 new records where added with resultid 3 and two new records with resultid 4.

there should have been in the header table records 1,2,3,4 only.

and in the child table there should have been two records with resultid 3, two with resultid 4.

Please have a look. I would really really appreciate it. I know im asking for alot. Thank you very much.