I have a project that requires a one to many relationship on a relatively large sscale. There are about 1/4 million "many" records and about half that many "one" records. I thought it would be good to use a local view with that relationship and all of the fields (including the keys) specified for update, for "send updates" to be checked. I think I need the keys specified because I will have to add records. In my load event I open the view with the nodata setting. Then when the user fills in one of the search fields, I create the view again with an SQL clause which is constructed from the value in the search field. I also respecify with dbsetprop the tables in the view, the key fields in the view, and that it should send updates. However in my testing, I can't seem to get the updates to persist even though I use "if tableupdate". Then when I go back to the view designer all of the update properties have been set to nothing. Any ideas?