Solve my Code - PHP, JQuery, Ajax

I want to create a dynamic form which will have the following fields: Date | Client | Station Product | Batch No | Quantity | Add / Remove Button ----------------------------SUBMIT button------------------- Date: Can only select current and future date. You cannot back date when selecting date on the form. Client: This is a dropdown field which should get Client Name from clients table Station: This is also a dropdown select field which should populate Station Name based on previous dropdown field selected in the Client dropdown. This filed should get data from station table. The above fields should be inline in the same line. Then will follow Product | Batch No | Quantity fields with Add / Remove buttons Product: This is a dropdown field which should get Product Name from products table Batch No: This is also a dropdown select field which should populate Batch Nos based on previous dropdown field selected in the Product dropdown. This filed should get data from batch table with batch no balance of > 0. Meaning if the batch no has a 0 balance it should not show in the dropdown options. Quantity: Quantity can only be selected based on the stock balance available in the batch table in the column named balance, User cannot input quantity value of more than balance value. Whenever we add rows, all quantities total also cannot be more than the balance available in stock in the batch table. We should have the following tables: client table with the following columns: c_id: client id int(11) Auto Increment client: This is client name varchar(50) c_add: Client Address text station table with the following columns: s_id: This is station id int(11) Auto Increment c_id: This is indexed related client id int(11) from the clients table c_id column station: This is station name varchar(50) products table with the following columns: p_id: This is product id int(11) Auto Increment product: This is the product name varchar(50) batch table with the following columns: b_id: This is station id int(11) Auto Increment p_id: This is indexed related p id int(11) from the product table c_id column batch: This is batch number double example 012345.23451 receivedqty: This is the quantity received of this batch deliveredqty: This is the quantity delivered of this batch. balance: This is the balance remaining of this batch Once the form is submitted: it will update orders table Order table will have the following column fields: order no: To be pre defined number like TLS_2002_0001 and keeps adding value at the end. date: Date captured from the form client: Client selected from the form station: Station selected from the form product: Product name selected from the form batch: Batch number selected from the form quantity: Quantity selected from the form and this should add the balance value from in the deliveredqty column in the batch table. if the User selected Add Rows button to capture multiple data, then we need to have additional columns added like for example the product,2 batch2 and quantity2 and this could be upto 10 different Added rows which means the columns can extend upto product10, batch10, qty10 Output table: Should be: order no | date | client | station | product | batch | quantity | .Totals at the side and at the bottom if more than one product or batch number rows was added by user then we should be able to see all the added products eg product2, batch2, qty and so on. Should be able to filter by Year and Month and Day Should also be able to filter by order no asc or dsc Should be able to filter by client or station Should be able to preview the order on display and also to download excel and pdf formats. Your input and creativity is also welcomed. Selection of the bidding process will be mainly onthe following: Cheapest Bidder with Lesser delivery time and on first come basis.