Maintain business contacts database on Mac and iPhone? My wife organises amateur and semi-pro orchestras. She has a ‘database’ of about 600 musicians which she currently keeps in an OpenOffice spreadsheet on the Mac, with each player’s name, instrument(s), contact details, some notes, and a record of which concerts they have played in. She’d now like to have this accessible on her iPhone (4S). It would be nice to be able to edit it on the iPhone, but not essential; it needs to be easy to keep the two copies in sync; it would be great if it was easy to call/SMS someone’s number from the iPhone database, but she doesn’t really want to merge the database with her iPhone address book.

I can think of a few different ways of solving this, for example:


view the spreadsheet on the iPhone using Quickoffice or Documents to Go
move the spreadsheet to Numbers on the Mac and iPhone, syncing via iCloud
use some sort of business contacts manager app, maybe adding contacts to groups to define both instrument played and concerts played in
create some sort of custom solution using Bento on the Mac and iPhone


I don’t have any of the above apps at the moment. Any advice on the ideas above, or any alternative suggestions please?
Using Numbers would work as you say it syncs when ever a change is made. The benefit of this is that it is customised to your wifes needs, i.e the filed Name, Instrument, etc, ect are what she needs.

Using Office to go adds a few unnecessary steps to the procedure, with iCloud everything just syncs.

If she were to buy a database package it is not likely to contain all the correct fields she requires and would contain a lot more that would be useless, so a bit overkill really.

However the benefit of having a database app like Bentois that all your contacts details are clickable on the app, so if she is looking for a bass player she will be able to search and then click the contact number to call them. However this has a much larger cost than just buying Numbers for iOS.