Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Editing a Field Used as View Filter Criteria
The nature of the beast on this application requires me to allow editing of a field that is used as the selection criteria for a grid's view. For example, on a grid on a form the user selects a record and second form appears with a grid. This second grid is based on a view using the social security number from the selected record as it's criteria. The point of this second form and grid is to allow editing of the social security number. It is not allow anywhere else in the system, but the user needs to be able to do it from time to time. The problem I have is after the field is changed and Save is selected, the subsequent TableUpdate causes the view to display all records except the one that was changed. I understand why this is so, but is there a logical way to save the record and have it appear in the grid at the same time? I'm thinking something about two views, one based on the other, but it's getting a bit murky the more I try to think about it... Any help is greatly appreciated... Thanks!
Regards, Renoir
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only