Database to manage costumers, orders, invoices and products: is it possible on iPad?
I am trying File Maker Pro because I would like to create a DB and then use it on an iPad thanks to FileMaker Go.
So, for what I have understood, if I want to have all data available when I am out of office, I have to copy the db on the iPad and start it from there using FM Go.
Then I have to copy the db on the computer if I want to update data locally and to backup it.
My question is about the amount of data and the complexity of the DB I can copy and use on an iPad.
I would like to have all my costumers details, about 1000 records, I want also to manage orders for the last 12 months, that could be about 40.000 records.
Further more I have about 5000 products with pictures, and invoices too.
I need to have all this data and have all tables working together to answer my queries and to input new records.
Is the iPad able to manage such amount of data?
I know it have limited system memory available...
Can filemaker be the solution for my project?
Thanks for any help about this!