Well I realise I was being a bit grumpy and dismissive, but this makes little sense either.
Bento is for beginners and casual users (i.e.- your Mum).
Your mother is not going to build a full-blown Cocoa app to interface with the thing, that's just a ridiculous suggestion.
I am a FileMaker developer so my point was just that unless I can stream data to and fro Bento's Libraries and Collections from the "serious" databases on the server, it remains as a stand-alone "HyperCard" like product with limited utility to an organisation. At this point, it is a user centric personal data organiser only.
Without FM integration, it's a recipe holder, with FM integration the possibilities are (or could be) endless.
Personally, I think the FM integration will come with the released product as it's a no brainer and I anticipate it being used (eventually) for the same uses you describe above. Today however, it's not even a finished product, let alone a part of iWork, let alone the underpinnings of data manipulation on the iPhone. I will start to get excited when it's released, and also when Apple announces how (or if), it fits into their plans.
I have programmed web and desktop db applications using various SQL dbs (including MS SQL Server, MSAccess, SQLite and FileMaker). I did not write the apps using FM, I just accessed FM databases.
My web programming language of choice is ColdFusion, but that is beside the point.
You can interface FM and and SQLite in any language that supports the JDBC and ODBC drivers.
So, yes, today, you or I can write an app that integrates FM and Bento dbs.
I don't believe that you can do the same with HyperCard (but I haven't looked at that for years).
If "with FM Integration", do you mean that you want to access the db with FM's programming environment? And that lacking that capability it is just a "recipe holder"?
Wouldn't that same logic apply to any dbms: Oracle, PostgreSQL, MySQL... yadda, yadda, yadda?
I don't mean to be pedantic, but disqualifying Bento as a serious db product just because FM doesn't recognize it, is plain silly!
What
other DBMS' have "FM integration"?
Maybe you are using the wrong tool-- I have mentioned several that can access both dbs-- why not use one of these?