Start Building Professional
Web Apps Today

Data to Mysql via Grid and parent form

I have a form called "JOB" and on the form is the standard PHP to MYSQL entry stuff like "name of job" "date" " employee" etc.
But I would like to also have an editable data grid to input information about materials used on the "JOB" and this 'materials' would
go to a seperate table in mysql as 'materials'. The 'materials' table would also be link to the 'job' table in mysql so I can track and view the materials.

Do I have to use XML to enter data directly into the mysql table? I don't want to have to use a seperate form to enter 'materials' for the "JOB" form. unless its a sub-form inside the parent form.


Thanks for any help

>>Do I have to use XML to enter data directly into the mysql table?
Not necessary , you can use form-integration feature of grid, so all data from grid will be included in form submit as separate fields, so you will need just save them in necessary table. 

http://dhtmlx.com/docs/products/dhtmlxGrid/doc/articles/Form_integration.html#grid_art_htmlform
http://dhtmlx.com/docs/products/dhtmlxGrid/samples/interaction_other_components/pro_form.html?un=1232621806000
http://dhtmlx.com/docs/products/kb/index.shtml?cat=recent&q=7478&ssr=yes&s=catchError