Hi all,
I'm currently deciding if FM is the best solution for me going forward, and have come here to hear from the experts.
My role is develop clinical data management systems for a medical department in a large hospital. The aim is to capture clinical data in a way that will improve clinical care, but also so that this data can be used for research purposes.
I should first of all point out that I'm based in Australia, and we are not known for our brilliant clinical data systems, my understanding is that the US is miles ahead of us (a product of the different funding arrangements, our health system is funded primarily by public money).
My aim to is to develop a simple system that can be accessible from a web based version as well as an iPad version. I will need the back end to be able to tap into a SQL database and possibly some old Oracle databases. We'll be looking at multiple users, maybe 10 concurrent users, all on site but across two different and not at all connected networks.
My main reason for looking into filemaker is the hiring practises of medical research. While the hospital has some main databases that are maintained by central IT, research money comes and goes. I think there is money for someone to be in this role for about four years, but beyond that, the databases I create may well have to stand on their own two feet without support, so I want the simplest possible platform that someone with no database experience can maintain and alter as needs change (I realise that this is a huge ask and maybe impossible, but I would like to get as close as possible). I know the mess that people with no experience can make to databases, but I would prefer this to having the whole thing fall over.
So, the impression that I'm getting is the FM is probably the simplest database platform for novices. And from all that I've read it should do what I want in terms of FM Go and web publishing.
Am I right? Am I wrong? Thought, opinions, anything at all would be greatly appreciated!!
Thanks,
K
PS I have no FM experience, I have a development background is MSAccess but with no real expertise. See, these medical research places hire people like me! Crazy right?