templates for customer orders database

[kategorgeous]

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