We would like to have a searchable database along with a downloadable app (for android or I-phones) created. The app would be a portal for the user to both input information into and retrieve information from the database.
Specifically, what we want to achieve is to create a database list of names and addresses. The composition of the database would include the following searchable field headings: Date, Sales Person Name, Business Name, Street Address, City, State, Zip Code and a field for Notes or Comments.
Dual functionality of the app:
1. Allows the user to input new information in all field headings and upload it to the database.
2. Provides a user the ability to query any field of the database. The retrieval of queried information is such that the more refined or precise a query, the closer the match. So that, if a search for the business name "STORE ABC" was executed, a list of "STORE ABCs" and their corresponding addresses would be listed. Whereas, a specific address for example, "123 N Park" may result in the list of only one exact match. We want two search field boxes, to be able to search by Business Name and Street Address.
Of upmost importance: since this is a confidential and proprietary list of names, ONLY the admin should possess access to the entire list. In other words, only the admin has the “backdoor” rights to see, manipulate, change, modify, or print the entire database of names. However, all “users” are allowed to input information or search the database (one field at a time, without the ability to view the entire list).