The Patient Scheduling system I have built extracts current inpatient data from an enterprise health system and merges it with data from a seperate database, based on a common key. This is then displayed in a gridview control for browse/update.
At any one point in time, the client list in my system should reflect the current inpatients in the enterprise system.
The problem is that if the user has not refreshed the client list in some time, there may have been a discharge in the enterprise system and the two get out of synch. When the user selects a client from the list to update, the details of an entirely different client (usually the one below), is presented in edit mode. e.g. if the user selects the 4th client in the list, the details for the 5th client are made available for update.
Any thoughts on how I can get around this.
...
Go to the complete details ...