Currently I'm doing SQL migration through remote view to my new product.
In this, how to handle the following case.
Single application will be access by each user and SQL DB in common server. Remote view [dbc] also common to all users. When one user add one record to a master table, how the changes will reflect to other user?
Also we are having the navigation tool bar. In this, if the user select Next or Previous how to refresh the remote view records for the changes done by other user? We can not call Rebury() at navigation level as every navigation selection system will try to refresh the view which will reduce the performance.
Help me, how to handle this efficient way.