The job is to create an iphone app that will create a database and synce with the same desktop database that will store information about clients, the clients projects, and allow my user(s) to update the status of the projects through their iphone on a weekly or bi-weekly basis.
The data base will need to be designed for 100 clients, each client having at least one project but some having 2 to 5, and each project having a list of tasks between 1 and 40 items. Each task will need to have a data entry field to give a status update on time intervals that are recorded by time/date sstamp