I'm using vb2005
I've a form with a one to many relationship. The 'many' table is displayed in a datagrid.
When I click the add new button on the binding navigator. A new blank record is created. After filling the fields on the 'one' table, I move on to the 'many' table which is a datagrid to fill in the fields. After filling the first line in the datagrid, I move on to the second line in the grid but the first line in the datagrid disappears. However, when click on the save button , the record in the datagrid reappears.
Let's say I've Department table with (Dept Id, Description) related to Section Table (Dept Id, Sect Id, Section description). One department can have many section.
I've painted the Department fields and the Section fields in a datagrid.
After creating a Department, I move on to the section grid to enter the sections (without clicking the store button). After entering the first section ID , I try to enter the second section Id. But when I click on the second row in the datagrid, the previously entered row disappeared. However when I click the store button, the previously entered section re-appears.
Any idea why?
Can you anyone tell me what is missing when designing one-to-many relationship?
Thanks