A Simple but Effective Solution
Ninox was chosen because it offers a solution which can be extended for multiple users and would therefore be able to grow with the business. Currently, it is essentially deployed as a single-user solution.
The solution was developed as a single database that could manage all the information required to make purchasing decisions in one place. Sitting behind the primary interface are multiple subsets of data which can be used for reporting, as well as updating the master database.
This meant that spreadsheet use was significantly reduced. Once a CSV file is uploaded to the database the system identifies duplicates, updates existing entries, and adds new ones. Users can search for specific drugs and identify suppliers and prices that meet their specific requirements.