I have a mysql database on my server that we use for managing contacts for our company. I have people that makes calls to people on those list through the day. Currently they are using just a simple form that ask the phone number and contact name and so on.
What I would like is the ability to have employees type the phone number in and a query is performed of the contacts table to return the contact name. then they add any comments and press submit and it post it to the call log table. can someone help me out with this?