I am going to develop an inventory system for a wholesaler, for tracking the transaction.I want to access database in the places named "shop" and "Store room" I want to get data which insert by the "Shop" in the "store". I can access data if it is on one computer but because of the two computers and the distance of the store and the Shop, I can't connect it. so i want to know that how can I manage this problem and what are the solutions are use in best practice. I read many books to find the solution but i couldn't find any solution. I want to know what are the technology may I use? Guide line for this. can I use java swing and MySql database.
