Hello and thank you for reviewing this project.
We need a single webpage template created. We have the design sketched out. Also, we have an Excel spreadsheet with all the data for an SQL database. Data might need to be normalized. To give you a ballpark with regards to database size there are roughly 200 customers and 10 principles.
The page which you will create will display information from the SQL database. To start, there will be 3 links: 1) "All customers" which would be a single line with all the customer's fields available. 2) "All Principals" which would be a single line with all the principals's fields available., 3) "All Customers & Principals" which would be a single line with both categories available.. Also, we'll need some basic flags in the database for noting customers are a part of a category, e.g. Customer X will show up when we click "All Customers" and not when we select Prospect.
Lastly, we need a way to add / edit / delete users. In the template there is a + and a - sign for user management. These will need to be active. Editing can occur in the display section of the template.
Thank you and we look forward to working with you.
- Brad