I need to convert a MS access application to a Web Application using PHP/HTML and Mysql or SQL Server.
It is a CRM application.
Form - navigate, search an appointment and select one
Form - appointment
- modify date
- modify hour
- select a contact
- modify type of appointment
- modify result (five yes/no fields)
- modify comments
- schedule a new one (just populate date and comments)
Form new appointment - idem form appointment, but with a search button in order to select a client.
This application will use 4 tables:
- type of appointment
I do not need to maintain the tables in the web application.
I only need to search an appointment, modify it and/or create a new one.
I have a web server we can use (Linux with MySQL) but I would prefer to use a SQL Server, I need some help with this as I don’t have much experience with web application.
Important: this will run in a Blackberry. Little screen, so we may use a multiple steps process to complete an appointment.
I will provide screen shots or a copy of my Ms Access database. You can copy layout.