Click to See Complete Forum and Search --> : Refilling Datasets


nunny
April 27th, 2003, 09:20 PM
I'm creating a screen with one Parent True DB Grid and 9 children based on it. They are all populated from a single Dataset object with one to many linkages created within the object using the View Schema option. My problem occurs when I add or update the Parent grid, sometimes the stored procedure will create updates to the children. I need those child grids to update automatically, but can't get them to do so. I've tried using the Data Adapter Update method, followed by Accept Changes, and then a variety of methods. But most just seem to ADD the records to the grids instead of replace them. In other words, if I have 4 records in a child grid, and I have 4 on the database, I will get 8 records in the child grid instead of just the 4 new ones. Does anyone know how to do this properly? Thanx!

:confused: :cool: