Let's say a client having a Head office in one location and it has other 3 subsidiary companies in three different locations. Also, it has the adsl connection from head office to subsidiaries.
The head office wants to see the three company sales in one application. I got stuck in the data reload. Could anyone suggest me the best option in reloading and what are the methods I can use.
As per my understanding the three companies having databases at three location.You need to Concatenate the records of all the three location. You can do this by using QVD files. First store the data of three subsidiary companies in three QVD files and Concatenate it with the data at head office. For subsequest updation use the appropriate query.
