We designed an operational software system that was installed in 2000 that has effectively run our entire business ever since. We hired a software programmer who wrote it in SQL Server 6 with the back end in Access which we access to manipulate data where needed. The server database is hosted on our office server. Each PC has the software installed locally on the C Drive with the system run over the network.
To meet the market demands, we needed each client can be a Customer or a Supplier. Each Bar under a Venue is added as a Service under the Client. Each Act under an Artist is added as a Service under the Client. Any acts that share members between Clients have a Partnership ID to ensure that the Business Booking Calendar shows accurate availability of Acts. We can build contracts between Admin Clients, Venues and Artists and have the ability to decline and add an alternative Admin Client in all transactions. All Activity is tracked and reportable.
(All Events – Gigs, Concerts, Tours, Festivals and Training Workshops)