Need help with a datagrid

[johncassell]

Hi, hope I've posted this in the right section, my apologies if not.

I need some help creating some datagrids but mainly the back end Table work.

I need 2 data grids as in the image below and they will behave like this:

For the Job DataGrid, a user will type in a job number and it will fill the datagrid with all the fitters who have worked on that job, along with Charged Hours and Actual Hours. They can add new lines and enter FITTERS NAME AND CHARGED HOURS ONLY. The Actual Hours will feed through from the information entered on the Fitters DataGrid.

I nearly have them complete but it is just getting the Actual Hours to feed through to the Job DataGrid. I don't really know how to go about it.

Any help at all would be really appreciated

Thanks

John

 

[johncassell]

Hi again, I see a lot of people have checked this out but no reply so I think I may have overcomplicated my request.

Please see the attached pic of my two tables and how the datagrid should behave.

The WorkedHours column will be read-only and should pull in the SUM of WorkedHours from the 'WorkedHours' table where the Job_Number = currently loaded job and Fitter Name = fitter named on that particular row.

Also, if someone understands me on that, would it be possible to contain the ChargedHours and WorkedHours in one table?

Thanks

John