Talking about a custom customer database, I eventually jumped into the deep end a couple of years ago and programmed my own using MS Access. It took a whole 6 months to figure out what I needed and programmed accordingly, but still I encounter problems with the exceptional customer; for instance a customer who insists on a tuning more than the average frequency, or a piano that changes owner, but not address. Still, I managed to get the whole lot integrated, even with the Pierce Atlas, and the local Street Map, billing, quotes, post codes, my ETD etc. I found that 99 percent of the programming is to get it to not do what you don't want it to do! Attached is a screen capture of my database interface which shows you basically the fields you might require. Names and addresses are fictitious in this example. AF Graphics at: https://www.moypiano.com/ptg/files/attachments/61/55/39/67/db1.jpg https://www.moypiano.com/ptg/files/attachments/99/c9/86/ac/db2.jpg Alternate URLs: http://tinyurl.com/yvrm http://tinyurl.com/yvrp
This PTG archive page provided courtesy of Moy Piano Service, LLC