Hi,
I know a little about MySql but hardly anything about PHP and I am tasked with creating a customer ordering database which will have four different tables which need to have various joins. The database part I can handle. What I am struggling with is an Order Entry screen where the user puts in the customer name and does a search - if the system finds the customer then they can select it and create an order, if the system does not find the customer it gives the option to create a new customer record.
Has anyone had any experience creating such a system and are there any PHP Templates available to assist creating the main input and search screens?
Thanks
Kate