Filemaker or Bento for project database?
I would love some help trying to decide on Filemaker (FMPA12) vs Bento (v4) for a department I'm setting up with a database. (We have both programs already so cost is not an issue).
I will do the setting up & the users who will then use the database are not technical or used to using databases.
It is for our community widows project. There is a list of about 300 women, with photos and various data. There is also a list of requests, with each request being linked to one woman. Then there is a housing list for those needing housing.
Bento is ideal in terms of its ease of use, but it doesn't quite do all I would like it do to. For example, if a woman comes into the office with a new request, I would like them to be able to add the request as a new record, then link it to the woman's profile, such that the list of requests automatically has the name, village, age etc. of that woman. I have experimented in Bento with the "related data" field, with which you can bring in the woman's entry into the Requests form, but it does not appear in the table list. The info can be copied and pasted though, but that doesn't feel quite like how you should be using a database.
Having only used Filemaker a little, I want to know if
a) I realistically could learn how to set up the database in this way - assuming FM does do what I am asking (I am fairly competent on software and have some time I could put into learning)
b) Whether the people using the database once it is set up would be fine or whether they would inevitably run into problems.