Ok heres the deal i am a professional multimedia producer. I currently work in the feilds of video, dvd, graphic design and web dev.
I am considering starting to use FileMaker Pro, however i don't know all that much about it so i hope someone could give me some advice.
I want to start using a project management database to track assests, jobs clients etc. Currently this is done in a rudenmentary format in access. The reason i use access is that a lot of the web dev work i do is dynamic dev in ASP and access is useful for creating small backends. However i find access to be cumbersome and ugly and in some ways limited. The other issue is that i am mostly mac based using a G5 and powerbook for most of my work, but whenever i want to use a database i have to either use the PC or make it in ASP and use it over the web (and in any case the access backend still can only be created and edited on the pc). So my reasons for looking at filemaker are to move to something more powerful and also so that i can use it on my mac. so a few questions i have are:
1/ Is it possible to have filemaker in one central network folder and then access it from both my macs an pc over the network, the way i would do it in access is to have a 1 backend with the data and 3 frontends
2/ are there any good project management apps for filemaker out there? (prefereably free or low priced ones) or would i have to make the db myself?
3/ What are my options with filemaker web wise? for example i would like to have elements of my project management database viewable online so my clients can see them (also edit them if possible?)
4/ Lastly i currenly use access for all my ASP web dev, is it possible to use filemaker instead of access backends, ie: just with a different connection string? or is this not possible?
As you might be able to tell i know very little about FM, so just tell me if i'm way off the mark. i have taken a look at the FM website and documentation but i would like a little impartial human advice!!! thanks in advance, alex