I am building a Wordpress Website For a client and they have some functionality they want to do that I am unfamilar with. I know it involves connecting a database with using a plug-in wpDatatables which will help with some of the functionality but does offer all of it. I need someone who is familiar with database and mysql coding I think. Below is some information.
1.) Editing Text Box with Typeahead (auto suggest), User will type prescription name in it and text will suggest correct name. Names will come from the Database as Mike suggested. User can still enter a new name. If user chooses an existing name, we should be able to get the Prescription Id, if he adds a new name we should be able to capture it as a new item
(2.) Once user types/chooses the name, next step is to enter additional info such as Dosage or other things
(3.) After this additional info user can enter this entry. At this time we can show this entry into WpTables. And Wptable can allow us to delete or change.
Once user is done with entire prescription he can save it.