Hi There,
From my experience .. data input is much faster in a text environment compared to a windows click here and there environment.
What would you suggest I use as an add on to PHP-MYSQL to complete this project ?
I am working on a PHP-MYSQL project that ideally would ...
Have one window with data(approx 40 different fields) to enter or update.
Data could be entered/updated by clicking directly on the specific field
(interactive validation would take place)
or
Data could be entered/updated from a quasi command line on the bottom.
A code would initially be entered in the quasi command line indicating the field to be entered/updated. Then additional fields would appear depending on the code.
As an example if the code is CU then field Customer is to be entered/updated and an interactive listing of customers pops up to help the user as he is entering the customer name. User may use Up Down keys to choose one of the suggested customers.
Once customer is selected his full info is displayed on top and the user may now enter a new code in the quasi command line to make other changes .. or type END to save and exit.
Is this possible ?
I was looking at Ajax-Javascript .. are there other options ?
I wrote a Unix based application 15 years ago which works great other than it is getting more and more limited in possibilities. My customers have looked at changing to newer windows based programs and have all found that they would require 10-15% more staff. So they prefer a quick and easy data entry system.
Thanks !
Michel
Montreal, Canada