Client has been utlizing an MS Excel Wkbk with multiple wkst.
The job will require some adaptability for future growth and allow for mobile apps, currently Android platform. The tables are fairly straight forward and will resemble a type of CRM software program, but industry specific. The wire frame work up is being done now for the concept, so the front end must be user friendly, data mining/querring must be fast and easy to make adjustments for field work.
Example: "client" is entered into program. All identifiers are then imported either via macro (website capture), or from manual entry (cut and paste). The second part will require photo's to be seen by user for proper identification purposes. The filed app will require two versions - one for new client data enry and 2nd for follow up with field teams.