|Riley Casey wrote on Tue, 26 September 2006 14:42|
I'm glad to hear that turned out for you Stuart. I'd be interested to know what direction you went on that.
Our solution (so far) only covers hires and invoicing, we've never gone as far as dealing with crew or vehicles. We've got a few folks on staff who can create stuff in Filemaker, so we have added lots of random things to keep track of specific processes, and also things like price lists for sales items etc. The advantage of this approach is that it's relatively easy for us to add new functionality as we require it, the main drawback is that we have a sprawling mess of something approaching two dozen different files, and lots of legacy stuff that we don't use any more but would be awkward to remove.
I've had a play with the latest version of Filemaker (8.5) and quite like the idea of starting from scratch and rewriting everything into a single multi-table file, but I'm dreading the amount of work that this would be.