-
I have the following : Access database with a number of tables, Data Environment Designer, with 1 Connection, and a command (for the first table), as well as a child command object (for the second table - has a foreign key to the first).
I also have 2 datagrids, for displaying the contents of the recordset.
The first datagrid displays the names of people in the first table, while the second grid, displays contact info for whatever record is selected in the first grid.
The user must be able to update both tables via the grid controls.
I can add new records to both grids, but my problem is the actual Requerying / Refreshing / Rebinding:
FOr a related (new) record in the first grid, a Contact Details record cannot be added to the second grid, until the recordset has been requeried, and the first grid rebinded. This I can understand, but what is inexplicable, is that the moment I rebind, after requering the recordset, my 2 grid controls do not allow adding of new records anymore!!!
I have tested the AllowAddNew property to be true, and all other properties seem as before. (when I could still add new records)
I have found that the only "proper" way to therefore update a new record is to actually end the application, and restart!!!!!. Can somebody please help me here - I must be missing something obvious.
-
Have you checked in the Command & Connection(Advanced Properties) that the Lock type allows writing back to table for both?
