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.

dhtmlx.com/docs/products/kb/inde … catchError