I am creating a business software package in visual basic.net that will handle invoices, quotes, purchase orders, inventory items, customers, etc. This program is multi-user meaning that different people could each be running an instance of the program on their computer, with each instance modifying a central database. The problem is that one instance of the program could for example add a new inventory item, then how would I make the other instances of the program update their inventory lists to recognize the change? The program works with a dataset that it stores locally to avoid extra calls to the central database, so how do I tell the program when to update its local dataset in one instance when another instance of the program made a change to the central database?
I hope that didn't confuse anyone. Any help is appreciated, I love examples :)