Dynamic Form with Validation

[Smurlos]

Hi everyone

I'm not really sure where to start searching with this one, everything I've searched for has come up with stuff not related to what I want.

I've made a rota website for my staff and at the moment if they want to request a period of time off work where they have 1 day off unpaid and then 2 days paid holiday, it has to be 2 seperate requests.

My old table structure is called 'request_list'

RequestID
StaffID
DateFrom
DateTo
RequestType
Status

In my proposed new procedure, I would have 2 tables as follows

'new_request_list'
RequestID
StaffID
DateFrom
DateTo
Status

'new_request_elements'
ElementID
RequestID
DateFrom
DateTo
Type
Status
Decision
Decision_By
Decision_Date
Decision_Reason

I'm trying to make it where they fill in one request, which then allows them to add 'lines' and each 'line' would be a period off work.

For example, you would complete the request with the period as 03/04/2013 - 06/04/2013

Then the first line they would enter as 03/04/2013 - 03/04/2013 and then select "Unpaid Day off"

I then want them to be able to click a button or link saying "add a line" that then inserts a new row of fields where they can enter 04/04/2013 - 06/04/2013 and then select "Paid Holiday" for example.

Then when they submit the form, there would be a new 'element' added for the request for each line added to the request.

However I need your help with the following:

• How would I do validation on each new line to ensure that the date from and to were completed?

• What code would allow me to add a new row to the database for each 'line' in the form?

I'd appreciate whatever help I can get.
It's been puzzling me for ages now.

Thanks 🙂